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

RMAN-06510: RMAN retention policy is set to recovery window of number days

ORA-19660: some files in the backup set could not be verified

RMAN-06186: PL/SQL package string.string version string in string database is too old

ORA-00155: cannot perform work outside of global transaction

DRG-12206: tag string already exists in section group string

TNS-00106: Failed to open log file

ORA-07599: spwat: $SCHDWK failure

ORA-24431: Statement does not exist in the cache

ORA-01173: data dictionary indicates missing data file from system tablespace

ORA-16814: incorrect log transport setting for standby's AlternateLocation

ORA-06808: TLI Driver: could not link IPX and ethernet streams

NNO-00809: Unknown OCI error: number

For more Oracle Errors Interview Questions Click Here