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

Aug 16 2011 11:07PM by ikickm

Solution to TSQL Beginners Challenge 1

select	EmployeeID
	,EmployeeName
	,Department
	,Salary
from
(
	select	*
		,DENSE_RANK() over(partition by department order by salary desc) SR
	from	@Employees
) SO
where SR = 2

Tags:

ikickm

2113 · 0% · 6

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