Database Errors Question:
Download Questions PDF

How to Select 38th row details in table without using rownum?

Answer:

Select * from Table_name
where rownum < 39
MINUS
Select * From Table_name
Where rownum < 38;

Download Database Errors Interview Questions And Answers PDF

Previous QuestionNext Question
Display details of employees who are senior to there own manager?TNS-00218: Current Bytes/Sec. : number