ANY answer.
Re: how can i select the third row from table?
You can use this and can select whichever row you want to select:
select * from (select rownum r,col_1,col_2,col_3,col_4 from table_name) t
where t.r='&z'
Last edited by deepak garg : 12-05-2007 at 11:05 AM.
|