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

how to select first 5 records from a table? : Sql dba

980

What is sql and db2?

1012

What are the string functions in sql?

981

What is pl sql block in dbms?

1009

What is the difference between sql and mysql?

1123

How do I install microsoft sql?

1056

Define commit, rollback and savepoint?

1033

Advantages and disadvantages of stored procedure?

1122

what is normalization? : Sql dba

1088

what is rdbms? : Sql dba

1018

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1016

How do you change a value in sql?

1022

How do I use google cloud in sql?

1093

What is dynamic sql in pl sql?

1038

What is the sql case statement?

1011