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 are the different types of database management systems?

1036

how to create a new table by selecting rows from another table in mysql? : Sql dba

1166

Is nosql relational?

999

is mysql query is case sensitive? : Sql dba

1163

Does truncate table reset auto increment?

1049

How to add new employee details in an employee_details table with the following details

1137

What is sap sql?

1029

Which is better join or inner query?

1125

What are %type and %rowtype for?

1106

Define select, insert, create, delete, update, drop keywords

1094

What is plpgsql language?

1141

What is data type in database?

1039

What is compiled query?

1084

How exception is different from error?

1065

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1300