Select ename,sal,deptno from emp where sal in (select max (sal) fr

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

Question Posted / k.prashanth

Answer Posted / k.prashanth

Select
ename,sal,deptno
from emp
where sal in
(select max
(sal) from emp
where
level<=5
connect by
prior sal<sal
group by level)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How many types of sql are there?

930

Enlist the advantages of sql.

939

What is sql profiler in oracle?

1015

Is postgresql a server?

997

Can we perform dml on view?

976

How can one get sql*loader to commit only at the end of the load file? : aql loader

1005

Can we use loop in sql?

924

How many developers work on postgresql?

917

Can %notfound return null after a fetch?

1005

How do I partition in sql?

904

what is a database transaction? : Sql dba

1108

Is left join inner or outer by default?

975

What do you mean by table in sql?

940

What is the current version of sql?

974

Why we use triggers in mysql?

938