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

What is forward declaration in pl sql?

758

What is native sql query?

736

what is the difference between inner and outer join? Explain with example. : Sql dba

728

Is primary key is clustered index?

724

Is postgresql a nosql database?

791

What is a nested table in word?

705

What is sql*loader and what is it used for? : aql loader

808

What is nosql db?

710

what is an extent ? : Sql dba

751

What is trigger with example?

739

How does join work in sql?

727

Mention what pl/sql package consists of?

724

How do you modify a table in sql?

800

Can procedure in package be overloaded?

837

What is difference between db2 and sql?

721