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 global cursor can be declare with dynamic trigger ?

2215

What is meant by truncate in sql?

1070

How can get second highest salary in sql?

994

what is rdbms? : Sql dba

1018

Does db2 use sql?

954

Is t sql a programming language?

1073

What is bitemporal narrowing?

1314

Differentiate between syntax and runtime errors.

1195

What does stand for in sql?

978

List different type of expressions with the example.

935

Is left join and outer join same?

1076

What is a relationship and what are they?

1155

What is difference between group by and partition by?

1066

What is the usage of distinct keyword?

1069

Explain the advantages and disadvantages of stored procedure?

1153