<p>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.</p>...

This challenge is about finding second highest salary for each department...

I submitted a solution for the SQL 2008 version of the challenge, but it doesn't show up....

CTE with a window function...

Actually, mine is slightly different. I just noticed you used Rank instead of Dense_Rank. Unless ORACLE "Rank" works different than SQL Server 2008 you need to use Dense_Rank otherwise it won't work....

Here is the simplest solution possible!...

Heh, you submitted before me, but for all intents and purposes my code is identical to yours. :)...

CTE with a Window Function...