what is the querry to get first 10 records from the emp
table?(emp no is the primary key)
- 4 Answers
- 8397 Views
- Verizon, I also Faced
- E-Mail Answers
Answer Posted / sunil
select * from emp where rownum<=10;
or
select * from (select rowid ri,e.* from emp e order by ri)
where ri<=10;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
