select * from ( select rownum r,a.* from TableName a ) where r=n't

how u can find the n row from a table?

Question Posted / santosh dwivedi

Answer Posted / santosh dwivedi

select * from
(
select rownum r,a.* from TableName a
)
where r=n'th

Is This Answer Correct ?

5 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What are some emotional triggers?

986

how many sql dml commands are supported by 'mysql'? : Sql dba

1125

What is pivot in sql?

918

what is the command used to fetch first 5 characters of the string? : Sql dba

1639

Is sql pronounced sequel or sql?

1273

Are subqueries faster than joins?

1022

What language is oracle sql developer?

1023

What is lookup table in sql?

1053

Is left join and outer join same?

1073

what is the difference between truncate and delete statement? : Transact sql

1067

what is user defined functions? : Sql dba

1037

What is before and after trigger?

963

Is sqlite free?

977

What is normalisation and its types?

1008

Where the sql database files are stored?

1021