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-37013: (XSACQUIRE_DEADLOCK) Cannot wait to acquire object workspace object since doing so would cause a deadlock.

TNS-00258: Number of Failed Requests : number

SQL*Loader-00959: Error shipping buffer across 2-task

ORA-24013: invalid value string, RETRY_DELAY should be non-negative

ORA-13622: The recommendation annotation string is invalid.

ORA-29340: export file appears to be corrupted: [string] [string] [string]

ORA-19018: Invalid character in XML tag 'string'

ORA-23500: cannot switch master for a multi-tier materialized view repgroup "string"."string"

ORA-14309: Total count of list values exceeds maximum allowed

ORA-16622: Two or more broker database objects resolve to one physical database.

ORA-28035: Cannot Get Session Key for Authentication

LPX-00605: Invalid attribute '~1S' in element '~2S'.

For more Oracle Errors Interview Questions Click Here