How to Select 38th row details in table without using rownum ?

Question Posted / nvsubbareddy

Answers were Sorted based on User's Feedback

How to Select 38th row details in table without using rownum ?..

Answer / vinu

select * from <tablename> where rownum='38'

Is This Answer Correct ?

2 Yes

15 No

How to Select 38th row details in table without using rownum ?..

sdf
sdf
f
sdf
sdf
sdf
sdf
sdf
sdf

Is This Answer Correct ?

4 Yes

18 No

More Oracle Errors Interview Questions

ORA-01279: db_files too large

IMG-00587: output format does not support the specified scanlineOrder

ORA-16640: CRS warns that multiple instances may still be running.

ORA-13218: max number of supported index tables reached for [string] index

ORA-07685: sou2os: supervisor stack set error

ORA-07283: sksaprd: invalid volume size for archive destination.

ORA-30489: Cannot have more than one rollup/cube expression list

ORA-01264: Unable to create string file name

ORA-01061: cannot start up a V8 server using a V7 client application

ORA-24770: cannot forget a prepared transaction

TNS-01079: Attempted to bequeath: string

TNS-01002: stop [<listener_name>] : stop listener

For more Oracle Errors Interview Questions Click Here