Saturday, January 14, 2012

SQL Query to get Second Highest Salary of the Employee


SELECT min(salary) AS high5 FROM employee WHERE salary IN(SELECT DISTINCT TOP 5 salary FROM orders ORDER BY salary DESC)

*** If the article helps you. Please like/Share it or leave a comment of appreciation !
Posted by at
Labels:

1 comment:

  1. ImranonlineJanuary 25, 2012 at 2:55 PM

    SELECT min(salary) FROM employee WHERE salary IN(SELECT DISTINCT TOP 5 salary FROM orders ORDER BY salary DESC)

    ReplyDelete

Subscribe to: Post Comments (Atom)