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


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.

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

Solution to TSQL Beginners Challenge 1

Oct 30 2010 1:21PM by vveasel   

Solution to TSQL Beginners Challenge 1

with DepartmentMaxSalaries as
(
	select Department, MAX(Salary) as MaxSalary 
	from Employees 
	group by Department
),
SecondSalaries as
(
	select Department, MAX(Salary) as SecondMaxSalary from Employees as s
	where Salary != (select MaxSalary from DepartmentMaxSalaries as d where d.Department = s.Department)
	group by Department
)
select * from Employees
where Salary = (select SecondMaxSalary from SecondSalaries  where SecondSalaries .Department = Employees.Department)
order by Department, EmployeeID

Tags:

vveasel
2114 · 0% · 6
0
Liked


Submit

Your Comment
Sign Up or Login to post a comment.
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]