select sal from emp a where 3=(select count(distinct(sal)) from emp b whe

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

Question Posted / somanath

Answer Posted / somanath

select sal from emp a where 3=(select
count(distinct(sal)) from emp b
where a.sal<=b.sal)

Is This Answer Correct ?

34 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is rollback?

1121

What are all different types of collation sensitivity?

1045

How you improve the performance of sql*loader? : aql loader

1021

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1215

What is t-sql? : Transact sql

999

Can a composite key be null?

990

how to escape special characters in sql statements? : Sql dba

1049

How do you declare a variable in pl sql?

1035

What does count (*) mean?

938

What does trigger mean in psychology?

972

Is nosql faster than sql?

1039

Explain the uses of control file.

1056

What are the differences between implicit and explicit cursors?

1072

How to Execute a Package in PL/SQL.?

1218

What is parallel hint?

1337