select * from (select * from emp order by sal desc) where rownum<=3;

a query to select maxmun 3 salaries of employee table

Question Posted / tulasi

12 Answers
20179 Views
IBM, Polaris, I also Faced
E-Mail Answers

Answer Posted / tulasi

select * from (select * from emp order by sal desc) where
rownum<=3;

Is This Answer Correct ?

21 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the logical operations?

1100

How to enter a new row into a table interactively?

993

Explain what are the uses of rollback segment?

989

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1982

what are archived logs?

2178

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2541

What do database buffers contain?

1002

What are a query and state the different types of queries and their uses?

998

How to use attributes of the implicit cursor in oracle?

982

What is the difference between hot backup and cold backup in oracle?

997

What is rowid and rownum in oracle?

992

What is index in Oracle?

1053

Which is faster join or subquery in oracle?

970

How to retrieve data from an explicit cursor?

1035

What do you mean by merge in oracle?

977