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

Answer Posted / tulasi

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

Is This Answer Correct ?

21 Yes

5 No

Please Help Members By Posting Answers For Below Questions

How to create a table index?

550

Will you be able to store pictures in the database?explain.

526

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1658

Why does for update in oracle 8 cause an ora-01002 error?

530

Is insert autocommit in oracle?

595

What is a tns file?

489

What is the difference between I and G in Oracle?

591

What is oracle datasource?

536

What do you mean by cdb and pdb in oracle 12c?

627

definition of cluster and non-clustered index?

2464

How do you find current date and time in oracle?

578

What is difference between truncate and delete?

547

What is a partition in oracle?

534

What is a sub query? Describe its types?

530

What is the difference between sharding and partitioning?

489