select min(sal) from (select sal from (select distinct(sal) from emp orde

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

Question Posted / arjun

Answer Posted / arjun

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

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is scalar function?

1002

How to create a menu in sqlplus or pl/sql?

1065

How do I send sql query results to excel?

1007

What is difference between stored procedures and application procedures?

958

Why we use joins in sql?

926

What is group by in sql?

1027

How is a PL/SQL code compiled?

1172

What is a unique key and primary key and foreign key?

920

What is primary and foreign key?

1017

Enlist the data types that can be used in pl/sql?

1013

What does t sql mean?

898

Can we insert data into view?

850

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

910

What is indexing in sql and its types?

1007

Which query operators in sql is used for pattern matching?

904