Select Query

ok try this<br><br><br>SELECT MAX(salary) AS Expr1 FROM employee WHERE <br>(salary NOT IN ((SELECT MAX(salary) AS Expr1 FROM employee<br> WHERE (salary NOT IN (SELECT MAX(salary) AS Expr1 FROM employee))),<br> (SELECT MAX(salary) AS Expr1 FROM employee)))<p><hr size="1" width="50%" align="left" />(#_#)</p>

How to get the third highest salary from the employee table.

Either with

SET ROWCOUNT 3 OR SELECT TOP 3

SELECT blabla FROM blabla WHERE blabla ORDER BY salary DESC

Then jump to the last line (MoveLast?)