what is the querry to get first 10 records from the emp table?(emp no is the

what is the querry to get first 10 records from the emp
table?(emp no is the primary key)

Question Posted / suresh

4 Answers
8175 Views
Verizon, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the querry to get first 10 records from the emp table?(emp no is the primary key)..

Answer / lara

SELECT column FROM table
WHERE ROWNUM <= 10

Is This Answer Correct ?

21 Yes

2 No

what is the querry to get first 10 records from the emp table?(emp no is the primary key)..

Answer / 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

what is the querry to get first 10 records from the emp table?(emp no is the primary key)..

Answer / 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

what is the querry to get first 10 records from the emp table?(emp no is the primary key)..

Answer / prachi

select TOP(10) from emp
orderby empid

Is This Answer Correct ?

1 Yes

8 No

Post New Answer

More Oracle AllOther Interview Questions

what is domain in database and its benefits?

0 Answers

i have marks in table,how to find total?

1 Answers

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

1 Answers

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

0 Answers

What is the difference between conversions and interfaces? : oracle accounts receivable

0 Answers

How do you create a credit note against an invoice? : oracle accounts receivable

0 Answers

For web applications from which version of Oracle is suitable?

1 Answers

Is there any link between pr form(purchse requisition)and po form(purchase order)

0 Answers L&T,

Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?

2 Answers

What is supporting issues GL AP and AR?

0 Answers Oracle,

What are the main diff. between oracle 7.3 and oracle 8i?

1 Answers

Describe what redo logs are.

1 Answers

For more Oracle AllOther Interview Questions Click Here