How to find the 9th row in emp table.

  • Interview Candidate
  • 15
  • 9773

Showing Answers 1 - 15 of 15 Answers

  • Sep 6th, 2011
 

select * from emp where rownum <=9 minus select * from emp where rownum<=8

  Was this answer useful?  Yes

Deepika Srivastava

  • Sep 7th, 2011
 

select * from EMP where ROWNUM=9

  Was this answer useful?  Yes

Sivaprasad

  • Apr 1st, 2015
 

Select ename,Sal from emp
where rownum < 10 minus Select ename,Sal from emp
where rownum < 9

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions