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

Give two methods you could use to determine what DDL changes have been made.

1 Answers

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

0 Answers

which one is currently in used software cmpanies.

0 Answers

What is the difference between the SQL*Loader and IMPORT utilities?

1 Answers

What is the mandatory setup in cyclecount ?

0 Answers Oracle,

How do you resize a data file?

2 Answers

What is Virtual Memory?

1 Answers

Explain the use of table functions.

0 Answers

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers

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

0 Answers Oracle,

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

0 Answers

How would you force a log switch?

1 Answers

For more Oracle AllOther Interview Questions Click Here