select min(sal) from(select distinct(sal) from emp order by sal desc) where

how to check the 3rd max salary from an employee table?

Question Posted / akula

Answer Posted / akula

select min(sal) from(select distinct(sal) from emp order by sal desc) where rownum<=3;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Are subqueries better than joins?

922

does sql support programming? : Sql dba

993

what is an alias command? : Sql dba

1011

What is the difference between execution of triggers and stored procedures?

1053

How to run pl/sql statements in sql*plus?

1024

Can we join tables without foreign key?

909

How to run sql*plus commands in sql developer?

1086

how can we know the count/number of elements of an array? : Sql dba

1007

What is constant in pl sql?

970

What is left join in sql?

1006

what are the advantages of sql ? : Sql dba

1000

Is not equal in sql?

960

Can we insert delete data in view?

899

What is not equal in sql?

1011

What makes a good primary key?

981