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

added by fabdulwahab
4/23/2010 11:55:37 AM

0 Kicks, 61 Views

Let us get started with the challenge. 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.