How to find the Nth highest salary from a table in SQL? 4:51:00 AM No comments SELECT DISTINCT (a.salary) FROM Employees A WHERE &N = (SELECT COUNT (DISTINCT (b.salary)) FROM Employees B WHERE a.salary<=b.salary) Share This: Facebook Twitter Google+ Stumble Digg Email ThisBlogThis!Share to XShare to Facebook
0 comments:
Post a Comment