select empid,salary from (select empid,salary from emp ord

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

Question Posted / amit bharane

Answer Posted / amit bharane

select empid,salary
from (select empid,salary
from emp
order by sal desc)
where rownum <=5;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How can I make sql query run faster?

963

What is sp_helptext?

1005

what are dynamic queries in t-sql? : Transact sql

963

How many triggers can be applied on a table?

882

How insert into statements in sql?

1011

how many sql dml commands are supported by 'mysql'? : Sql dba

1059

What are the 3 modes of parameter?

1103

What is identity column in sql server?

988

What is cross join sql?

868

Difference between truncate, delete and drop commands?

1025

Is keyword pl sql?

933

What is the purpose of the sql select top clause?

1021

What are the different dml commands in sql?

1090

What is the difference between left outer join and left join?

945

What is sql*loader and what is it used for?

1047