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
7255 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

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers

HOW TO SPOT AHIERARCHY?

0 Answers

what are basic modules required to implement oracle application in any oraganisation?

0 Answers

How would you determine what sessions are connected and what resources they are waiting for?

0 Answers

Explain the use of table functions.

0 Answers

how to replace not in with not exist?

0 Answers IBM,

Why more redos are generated when the oracle database is in begin backup mode?

0 Answers

pl help me, i want oracle HRMS training institute address,in chennai

8 Answers

What is mrc and what is its use? : oracle accounts receivable

0 Answers

Could you please let me know the interfaces in OM / FA??

0 Answers Oracle,

I need a Technical evaluation between Oracle and SAP ? please do a need ful.

0 Answers

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

0 Answers

For more Oracle AllOther Interview Questions Click Here