Go Back   Site Owners Forums - Webmaster Forums > Search Forums

Notices


Showing results 1 to 1 of 1
Search took 0.00 seconds.
Search: Posts Made By: Pavan Techn
Forum: PHP / mySQL 06-01-2018, 10:16 AM
Replies: 0
Views: 8,991
Posted By Pavan Techn
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;
Showing results 1 to 1 of 1

 
Forum Jump

All times are GMT -7. The time now is 05:38 PM.


Powered by vBulletin Copyright © 2020 vBulletin Solutions, Inc.