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

NNL-01071: Command-line parameter file name: string

ORA-27214: skgfrsfe: file search failed

ORA-38412: Expression set column string does not exist.

ORA-07280: slsget: unable to get process information.

QSM-00794: the statement can not be stored due a violation of the string filter

ORA-09839: removeCallback: callback port is not in the callback set.

ORA-33427: (EIFMAKEF16) CAUTION: NTEXT object workspace object will be exported with type TEXT.

PLS-00591: this feature is not supported in client-side programs

ORA-38727: FLASHBACK DATABASE requires a current control file.

ORA-13153: invalid high water mark specified

ORA-30344: number of child cols different from number of parent level cols

ORA-23427: deferred purge queue argument string out of range

For more Oracle Errors Interview Questions Click Here