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 scope and visibility in PL/SQL?

1110

Why is partition used in sql?

1049

What is union?

1079

How do you determine the current isolation level? : Transact sql

1064

Can we perform dml in function?

1013

What is recursive join in sql?

945

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

928

What is rownum in sql?

963

How do I edit a stored procedure?

945

How many triggers can be applied to a table?

992

What is relationship? How many types of relationship are there?

1068

Why primary key is required?

935

What is rank function in sql?

958

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

896

What is cursor in pl sql?

1049