select * from (select e.*,rank() over(order by salary desc nulls last) sa

Find out the 3rd highest salary?

Question Posted / srikanth

Answer Posted / srikanth

select * from (select e.*,rank() over(order by salary desc
nulls last) sal_rnk from employee e)where sal_rnk=3;

Is This Answer Correct ?

3 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is the difference between between and in condition operators?

989

Why is stored procedure faster than query?

936

Is sql dba a good career? : SQL DBA

978

How do you rank data in sql?

984

Write a sql query to convert all character to uppercase after hypen.

1418

How do I find duplicates in two columns?

1136

How many commands are in sql?

1052

Are there any features that are decommissioned in 11g that are not present in 11g?

2127

how to analyze tables with 'mysqlcheck'? : Sql dba

997

what are the different functions in sorting an array? : Sql dba

1005

What is a full join?

961

How can you select unique records from a table?

1057

How can we implement rollback or commit statement in a trigger?

1019

How to avoid using cursors?

1102

what is the difference between blob and text? : Sql dba

1004