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
50901 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 / yogesh sharma

SELECT ENAME,SALARY FROM (SELECT ENAME,SAL FROM EMP ORDER BY SALARY DESC ) WHERE ROWNUM<6;

Is This Answer Correct ?

77 Yes

13 No

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

Answer / priya

SELECT Rownum,emp-name,salary
FROM(SELECT emp_name,salary
FROM employees
ORDER BY salary Desc)
WHERE Rownum<=5;

Is This Answer Correct ?

17 Yes

3 No

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

Answer / sankarapandian

select top 5 salary from employee
order by salary desc

Is This Answer Correct ?

17 Yes

8 No

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

Answer / sarath

select ename,sal,SAlrank from(select ename,sal,dense_rank()
over(order by sal desc) Salrank from emp)
where salrank <=5

Is This Answer Correct ?

9 Yes

2 No

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

Answer / nitin umale

SELECT last_name, salary
FROM (select last_name, NVL(salary,0) salary
FROM employees
ORDER BY NVL(salary,0) DESC )
WHERE rownum<6;

Is This Answer Correct ?

9 Yes

3 No

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

Answer / sreenivasreddy

SELECT ROWNUM, E1.*
FROM (SELECT EName, Deptno, Sal,
DENSE_RANK()
OVER(ORDER BY Sal DESC) EmpRank
FROM Emp
GROUP BY Deptno, EName, Sal
ORDER BY EmpRank) E1
WHERE E1.EmpRank <= 5
ORDER BY ROWNUM

Is This Answer Correct ?

6 Yes

2 No

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

Answer / vishnu

select level,max(sal) from emp
where level<=5
group by level
connect by prior sal>sal
order by level Asc;

Is This Answer Correct ?

5 Yes

3 No

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

Answer / mk

SELECT ENAME,SALARY FROM (SELECT ENAME,SAL FROM EMP ORDER
BY SALARY DESC ) WHERE ROWNUM<6;

Is This Answer Correct ?

1 Yes

0 No

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

Answer / seetharam

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

Is This Answer Correct ?

3 Yes

3 No

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

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

Post New Answer