retrieving 8th record from emp table in scott instance select * from emp

How to find 8th person record in a table?
Plz mail ur answers to
mak2786@gmail.com

Regards
Arun

Question Posted / chaitanya.s

Answer Posted / chaitanya.s

retrieving 8th record from emp table in scott instance

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

Is This Answer Correct ?

9 Yes

3 No

Please Help Members By Posting Answers For Below Questions

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2372

please send me oracle pl/sql exp resume. and also faqs...

2588