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

What is sqlcontext?

1091

Does pl sql work in mysql?

989

What is sql comments?

1081

What is scalar data type in pl sql?

1076

What is full join in sql?

1002

How do you explain an index?

1287

Can I learn sql in a week?

1086

tell me about various levels of constraint. : Sql dba

1041

how to create a new view in mysql? : Sql dba

945

What is execution plan in sql?

1057

What is difference between mysql and postgresql?

1164

What are all the common sql functions?

1039

Does user triggers have entry for trigger with compilation errors?

1045

How can we debug in PL/SQL?

1139

What is a stored procedure in sql with example?

1139