Write an SQL query to get third maximum salary of an employee from a table named empl
SELECT TOP 1 salary
FROM ( SELECT TOP 3 salary FROM employee_table ORDER BY salary DESC ) AS emp ORDER BY salary ASC; |
All times are GMT -7. The time now is 06:03 PM. |
Powered by vBulletin Copyright © 2020 vBulletin Solutions, Inc.