PLSQL Challenge 2 - Find the second highest salary for each department - A Solution

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


	ORACLE - PLSQL Challenges

Upload Image

Close it

Select File

This challenge is about finding second highest salary for each department


	Like

Invite Friends

PLSQL Challenge 2 - Find the second highest salary for each department

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

A Solution

Nov 1 2011 8:12AM by sjb500

;WITH m AS
(
	SELECT Department,MAX(Salary) ms FROM #PLC2_Employees a
	where Salary<(SELECT MAX(Salary) FROM #PLC2_Employees WHERE Department=a.department)
	GROUP BY Department
)
SELECT * FROM PLC2_Employees e
INNER JOIN m
ON e.Department=m.Department AND e.Salary=m.ms
ORDER BY 3

Tags:

sjb500

1217 · 0% · 20

Liked


Post this to my facebook wall
Tweet this
Like this


	Submit

1 Comments

The object name "#PLC2Employees" is wrong . It should be PLC2Employees

commented on Nov 3 2011 4:55AM

PLSQL Challenge 2 - Find the second highest salary for each department

A Solution

1 Comments

Your Comment