Thursday, 10 November 2011

How to find the highest salary using SQL?

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 6 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)