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

What are character functions in sql?

908

Is primary key clustered or nonclustered?

971

How do I remove all records from a table?

1047

How do I create an index in word?

982

What is the advantage of nosql?

1019

Do we need commit after truncate?

1050

What is pl sql record in oracle?

987

How do I filter in sql profiler?

966

What is an ndf file?

950

How to get list of all tables from a database?

1124

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1092

What is rank function in sql?

982

How many developers work on postgresql?

932

how to select first 5 records from a table? : Sql dba

942

how would you get the current date in mysql? : Sql dba

936