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

Jun 23 2011 5:20AM by pradeep

Solution to TSQL Beginners Challenge 1

With cte
as
(
select top 100 percent DENSE_RANK() OVER (PARTITION BY Department ORDER BY salary DESC) RANK1,*from @Employees ORDER BY Salary DESC
)

SELECT EmployeeID,EmployeeName,Department,Salary FROM cte WHere RANK1=2

Tags:

pradeep

636 · 0% · 53

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