TSQL Beginners Challenge 1 - Find the second highest salary for each department - Solution to TSQL Beginners Challenge 1

Getting Started with Adobe After Effects - Part 6: Motion Blur


	TSQL Beginners Challenges

Upload Image

Close it

Select File

The challenge is to find the employees with the second highest salary in each department. However, it is a little more complicated because if two employees have the same salary, you need to list both of them.


	Like

Invite Friends

TSQL Beginners Challenge 1 - Find the second highest salary for each department

Home · Challenge Details · Comments · Solutions · Fans (186) · Preferences

Solution to TSQL Beginners Challenge 1

Mar 22 2011 7:15AM by sqlpadawan

Solution to TSQL Beginners Challenge 1

SELECT EmployeeID, 
       EmployeeName, 
       Department, 
       Salary
FROM ( SELECT EmployeeID, 
              EmployeeName, 
              Department, 
              Salary,
               RANK() OVER(PARTITION BY Department ORDER BY Salary DESC) AS RankNo
       FROM @Employees
     ) AS FOO
WHERE RankNo = 2

Tags:

sqlpadawan

1280 · 0% · 18

Liked


Post this to my facebook wall
Tweet this
Like this


	Submit

Your Comment

Sign Up or Login to post a comment.

TSQL Beginners Challenge 1 - Find the second highest salary for each department

Solution to TSQL Beginners Challenge 1

Your Comment