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

Can a composite key be null?

515

How do I edit a stored procedure?

539

What are the operators in sql?

515

how is exception handling handled in mysql? : Sql dba

538

What is scalar and vector?

519

What is a unique key?

575

What is graph sql?

515

Which are sql * plus commands?

529

What are all the common sql functions?

553

What is sql injection vulnerability?

488

What are the properties of a transaction?

548

How do I start sql from command line?

520

Can %notfound return null after a fetch?

577

What is difference between group by and partition by?

484

Is primary key a clustered index?

525