Solution 2 doesn't qualify condition asked
Solution 2 doesn't qualify condition asked
IN Solution 2 second row_number column asked for partition in the question but in the solution is solved without partition (which basically same as we did in Question 1) please update this
Thanx for this amazing course
ROW_NUMBER() OVER () AS row_num1, #This was given
ROW_NUMBER() OVER(PARTITION BY s.emp_no ORDER BY s.salary) as salary_high, #instead this was True for given Condition
1 answers ( 0 marked as helpful)
Hi Mayank!
Thanks for reaching out.
The solutions are switched. Thanks for spotting this.
Hope this helps.
Best,
Tsvetelin