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-31199: Warning in processing file string

DRG-11480: ctxkbtc memory allocation error: %(1)

ORA-31162: element or attribute "string" has no SQLType specified

KUP-03017: length specified for VARIABLE records must be greater than 0

ORA-16764: log tranport service for some standby database unexpectedly offline

DGM-16951: Can not proceed to failover.

ORA-00447: fatal error in background process

ORA-31529: could not find publication for CDC subscriber view string.string

KUP-04021: field formatting error for field string

ORA-25177: UNRECOVERABLE option not permitted

TNS-00552: no valid cipher suites were specified

RMAN-06733: database unregistered from the recovery catalog

For more Oracle Errors Interview Questions Click Here