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-36685: (XSDPART23) Only CONCAT partition templates can be subpartitioned.

DRG-11120: failed to write to file string

ORA-24377: invalid OCI function code

ORA-26501: RepAPI operation failure

TNS-12208: TNS:could not find the TNSNAV.ORA file

ORA-00018: maximum number of sessions exceeded

ORA-24273: translation text is required if translation type is T or S

ORA-02212: duplicate PCTFREE option specification

ORA-24096: invalid message state specified

DRG-11862: This Is Probaly A HTTP Server 0.9 Or Less

ORA-24400: error occured while creating connections in the pool

NID-00110: Cannot use REVERT and specify a database name at the same time

For more Oracle Errors Interview Questions Click Here