SELECT ROWNUM, E1.* FROM (SELECT EName, Deptno, Sal, DENSE

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

Question Posted / sreenivasreddy

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

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is subquery? : Sql dba

1068

Can we join two tables without common column?

932

Is sql easier than java?

947

Is inner join faster than left join?

1125

Why is a trigger used?

890

how to rename an existing table in mysql? : Sql dba

1007

What is user defined functions?

918

Is mariadb nosql?

993

Can we call stored procedure in function?

905

Can you rollback after commit?

936

What operating systems are supported by oracle sql developer?

904

How would you pass hints to the sql processor?

922

How do you truncate?

855

Explain the difference in execution of triggers and stored procedures?

969

what are the join types in tsql? : Transact sql

983