select max(sal) from emp where sal not in(select max(sal) from emp where

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

Question Posted / kumar sumit

Answer Posted / kumar sumit

select max(sal) from emp where sal not in(select max(sal)
from emp where sal not in(select max(sal) from emp))

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

what is sql server agent? : Sql dba

1173

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

1051

Do we need to rebuild index after truncate?

1128

What is the current version of sql?

1091

Is primary key always clustered index?

1090

what is schema? : Sql dba

1130

what is dbms? : Sql dba

1055

define sql insert statement ? : Sql dba

1092

what are all the common sql function? : Sql dba

1123

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

1138

Does group by remove duplicates?

1107

what is collation? : Sql dba

1224

What is the best sql course?

1042

what are aggregate and scalar functions? : Sql dba

1122

Is primary key clustered index?

1010