Database Challenges

TSQL Beginner’s Challenge #1 – Find the second highest salary for each department

In a nutshell, 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.

• Challenge 1 - All Solutions
• Challenge 1 - Accepted Solutions
• Challenge 1 - Basic Testing
• Challenge 1 - Basic Testing Results
• Challenge 1 - Logic Testing Sandbox
• Challenge 1 - Winners