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

the user should know to which database he is connected currently in oracle

3 Answers

hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent

1 Answers

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

0 Answers

Can we modify approve purchase order?if yes what is navigation?

0 Answers L&T,

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

0 Answers

Explain prerequisites and post activities of oracle database installation

0 Answers

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

0 Answers

What is the difference between oracle media recovery and crash recovery?

0 Answers

can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )

1 Answers IBM, Oracle,

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

0 Answers

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

0 Answers

what is domain in database and its benefits?

0 Answers

For more Oracle AllOther Interview Questions Click Here