SELECT * FROM (SELECT Ename,Sal, DENSE

Find out the 3rd highest salary?

Question Posted / av.anil

Answer Posted / av.anil

SELECT * FROM
(SELECT Ename,Sal,
DENSE_RANK()
OVER(ORDER BY Sal DESC) "D_RK"
FROM Emp)
WHERE D_RK = 3;

This query gives exact highest salary.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

where are cookies actually stored on the hard disk? : Sql dba

1001

Why indexing is needed?

961

Is inner join faster than left join?

1146

How to start the command-line sql*plus?

1027

What is a database trigger?

1036

What are the dml statements?

1116

how many ways we can we find the current date using mysql? : Sql dba

1061

What is the difference between microsoft access and sql server?

1017

What are database links used for?

1015

What is difference between my sql and sql?

1025

What is a pragma statement?

1240

How do you create a db file?

978

Does a primary key have to be a number?

934

What is indexes?

1030

What is sql analyzer?

980