|
|
-
First select the Highest Salary from each department and then again select the Highest salary but not in first Highest salary.
...
|
-
Do u like this answer. I think it skould work. Please try it and let me know if it works...
|
-
This challenge is about finding second highest salary for each department...
|
|
|
-
My solution was very similar to another submitted solution. However, I really prefer CTEs over sub queries. Another benefit is Oracle's sub query factoring (not in use here), which will usually be more efficient (but not always!)....
|
-
This challenge is about finding second highest salary for each department...
|
-
Jacob, I am actually clear with that but the reason for which I asked because in one of the challenger's solution, I found the answer to be
With Cte(Column name(s)...)
kind of syntax which will run only in Oracle 11g R2+... and the solution is co...
|
-
The notes section says it is 10G
> The solution should work on Oracle 10g
> or later versions....
|
-
Hi I am curious to know on what version of Oracle will the solutions be tested? Oracle 10g or some higher version? It will be helpful to know that in advance as there are some features (e.g. Recursive CTE, Pivot, Unpivot etc. only to name a few) which a...
|
-
This challenge is about finding second highest salary for each department...
|