Database / SQL
SQL to find the 3rd highest salary.
You can get the third-highest salary by using limit, by using TOP keyword and sub-query. TOP works with MS SQL server and LIMIT works with MySQL.
TOP keyword:
SELECT TOP 1 salary FROM (SELECT TOP 3 salary FROM Table_Name ORDER BY salary DESC) AS Comp ORDER BY salary ASC limit:
SELECT salary FROM Table_Name ORDER BY salary DESC LIMIT 2, 1 by subquery:
SELECT salary FROM (SELECT salary FROM Table_Name ORDER BY salary DESC LIMIT 3) AS Comp ORDER BY salary LIMIT 1; More Related questions...
