Last answered:

26 Apr 2023

Posted on:

31 Jan 2023

1

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)
Instructor
Posted on:

26 Apr 2023

1

Hi Mayank!
Thanks for reaching out.


The solutions are switched. Thanks for spotting this.


Hope this helps.
Best,
Tsvetelin

Submit an answer