Exercise 1 question

Question

Hello! In exercise 1 you are asked to order result by the first row_number column and by salary in ascending order. In most cases all is fine, but for some managers you receive switches in salary order. Output on the screen is from the solution file. I got the same trouble so I wanted to check how it was fixed in solutions)

Answer 1

Hi,

in this case row_num1 is prevailing factor of sorting, so the numbers are: 57, 58, 59 etc,

WHILE in row_num2 - i.e. salary rank is 15, 13, 14. The salary order would be right, if there were not the 1 sorting condition = row_num1.

I hope this helps,

Regards

Małgorzata

Exercise 1 question

Submit an answer

related questions