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-25960: join index cannot be based on a temporary table

PCC-02396: Illegal use of arrays inside an array of structs

PLS-00617: at least one result in the CASE expression must not be NULL

ORA-09914: Unable to open the ORACLE password file.

QSM-01007: query has NOREWRITE hint

UDE-00011: parameter string is incompatible with parameter string

ORA-23443: missing template parameter

ORA-16588: no more internal buffers

TNS-12205: TNS:could not get failed addresses

ORA-09700: sclin: maximum number of latches exceeded

ORA-31409: one or more values for input parameters are incorrect

ORA-09746: smscre: shared memory attach address incorrect.

For more Oracle Errors Interview Questions Click Here