SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY < (SELECT MAX(SALARY) FROM EMPLOYEE)
SELECT SALARY FROM Employee t1 WHERE 2=(SELECT COUNT(DISTINCT t2.SALARY) FROM Employee t2 WHERE t2.SALARY >= t1.SALARY)
SELECT TOP 1 Column1 FROM Table1 WHERE Column1 <> (SELECT MAX(Column1) FROM Table1) ORDER BY Column1 DESC
SELECT TOP 2 column FROM table LIMIT 1, 1
SELECT TOP 1 SALARY FROM Employee WHERE SALARY IN (SELECT TOP 2 SALARY FROM Employee ORDER BY ASC)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)