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