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

PLS-00619: the first operand in the NULLIF expression must not be NULL

ORA-01164: MAXLOGFILES may not exceed string

ORA-29387: no top-plans found in the pending area

PLS-00650: invalid type for PARTITION/CLUSTER/ORDER BY clause

NNL-00512: Shows or sets the server's auto-refresh expiration period

ORA-19592: wrong string conversation type

PCC-02385: CHAR_MAP disallowed when using NLS_CHAR and NLS_LOCAL=TRUE

ORA-32822: subscriber string is marked for removal

LCD-00204: left parenth and no parameter specified [string]

ORA-32152: Cannot perform operation on a null number

ORA-32772: BIGFILE is invalid option for this type of tablespace

ORA-01881: timezone region id number is invalid

For more Oracle Errors Interview Questions Click Here