SELECT min( sal ) FROM emp WHERE sal IN ( SELECT DISTINCT sal FROM e

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

Question Posted / danny

Answer Posted / danny

SELECT min( sal )
FROM emp
WHERE sal
IN (

SELECT DISTINCT sal
FROM emp
ORDER BY sal DESC
LIMIT 0 , 3
)

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is inner join faster than left join?

1273

what is sql server agent? : Sql dba

1173

what are all the common sql function? : Sql dba

1123

What is the current version of postgresql?

1162

what is collation? : Sql dba

1224

Does group by remove duplicates?

1107

What is your daily office routine?

2338

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

1105

Can we use distinct and group by together?

1129

Can delete statement be rollbacked?

1050

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

1138

define sql insert statement ? : Sql dba

1092

Is primary key always clustered index?

1090

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

1109

Do we need to rebuild index after truncate?

1128