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-24315: illegal attribute type

ORA-23365: site string does not exist

ORA-28177: incorrect Kerberos ticket version

RMAN-06127: skipping read-only file string

NID-00397: Changing database name from string to string

ORA-13015: the window definition is not valid

DRG-50925: could not parse return value of PL/SQL

ORA-25237: navigation option used out of sequence

ORA-36806: (XSTBLFUNC03) The OLAP_TABLE function refers to an invalid ADT attribute: string.

ORA-22338: must specify CASCADE INCLUDING DATA when altering the final property

RMAN-06475: parallelism setting out of range (1-254): number

ORA-32500: Dirname 'string' cannot exceed 'number' characters

For more Oracle Errors Interview Questions Click Here