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-19751: could not create the change tracking file

ORA-00329: archived log begins at change string, need change string

ORA-13525: error with computing space usage for sysaux occupant

RMAN-08025: channel string: copied controlfile copy

ORA-14454: attempt to reference temporary table in a referential integrity constraint

ORA-32054: lost communication with FMPUTL process

ORA-19642: incremental-start SCN is string

ORA-27036: translation error, unable to expand file name

ORA-24762: server failed due to unspecified error

ORA-30017: segment 'string' is not supported in string Undo Management mode

ORA-07233: slemcw: invalid file handle, seals do not match.

ORA-16550: truncated result

For more Oracle Errors Interview Questions Click Here