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 dbms? : Sql dba

1060

how to use regular expression in pattern match conditions? : Sql dba

1105

define sql insert statement ? : Sql dba

1094

Does group by remove duplicates?

1108

Can we use distinct and group by together?

1130

Can we rollback truncate?

1072

Is primary key always clustered index?

1090

how to start mysql server? : Sql dba

1258

If a cursor is open, how can we find in a pl/sql block?

1235

what are aggregate and scalar functions? : Sql dba

1122

What is the best sql course?

1042

Is primary key clustered index?

1013

what is sql server agent? : Sql dba

1175

what is bcp? When does it used? : Sql dba

1053

how many tables will create when we create table, what are they? : Sql dba

1140