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

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

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

Question Posted / lmeher.tcs

24 Answers
52262 Views
Cap Gemini, iNautix, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / 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

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

Answer / manoranjan sethy

Method 01:
---------
Select Ename, MAX (Sal) From Emp
Group by ROWNUM, Ename
Having Rownum <=5;

Is This Answer Correct ?

0 Yes

0 No

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

Answer / vivek dubey

this Query is wrong : " SELECT ENAME,SALARY FROM (SELECT ENAME,SAL FROM EMP ORDER BY SALARY DESC ) WHERE ROWNUM<6; " because We can not use Order by clause in SubQuery.

This Answer gives you the right data :

"
SELECT TOP 5
empsal.ENAME,
empsal.SAL
FROM
(
SELECT ENAME,SAL
FROM EMP
) AS empsal
ORDER BY empsal.SAL DESC
"

Is This Answer Correct ?

0 Yes

0 No

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

Answer / ajay dond

select salary from (select distinct salary from employees
order by salary desc)
where rownum<6

Is This Answer Correct ?

0 Yes

0 No

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

Answer / ram

select ename,salary from(select ename,salary from emp order by salary desc) where rownumber<6

Is This Answer Correct ?

0 Yes

0 No

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

Answer / kishore

select salery from (select salery from
emp order by salery desc) where rownum <=5 ;

Is This Answer Correct ?

2 Yes

3 No

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

Answer / manjunath u

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

Is This Answer Correct ?

0 Yes

1 No

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

Answer / alex, n.y [microsoft]

SELECT TOP 5 [SALARY] FROM [EMP]

Is This Answer Correct ?

3 Yes

4 No

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

Answer / kavitha nedigunta

select a.*
from(select empno,ename,sal
from emp
order by sal desc nulls last)a
where rownum <6
order by sal desc

Is This Answer Correct ?

3 Yes

5 No

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

Answer / mohammad murtuza ali

select * from emp as(empname,empsal,empdesc) where rownum<6

Is This Answer Correct ?

1 Yes

4 No

Post New Answer