|
|
-
Great minds think alike!! :)
I'm sure you're right about Rank(). I don't have access to our Oracle box right now to validate it, so I did my initial test on SQL Server 2008....
|
-
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...
|
-
This challenge is about finding second highest salary for each department...
|
-
Here is the simplest solution possible!...
|
-
This challenge is about finding second highest salary for each department...
|
|
|
|
|