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

Write a query to find five highest salaries from EMP table.
(there is a column SALARY)

Question Posted / seetharam

Answer Posted / seetharam

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

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What are sql triggers used for?

996

what are all types of user defined functions? : Sql dba

1042

Can there be more than one function with a similar name in a pl/sql block?

985

Is sql harder than python?

1108

Does sql full backup truncate logs?

1018

Does truncate table reset auto increment?

994

what are numeric data types? : Sql dba

1064

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1138

what is recursive stored procedure? : Sql dba

987

Which table is left in join?

979

What do you mean by stored procedures? How do we use it?

996

What is the difference between a procedure and a function?

1113

What is the difference between function, procedure and package in pl/sql?

1264

explain the difference between bool, tinyint and bit. : Sql dba

1002

What is pivot table in sql?

1109