Last answered:

14 Dec 2022

Posted on:

16 Nov 2022

1

Resolved: I am not sure what minus means, may you illustrate

I am not sure what minus means, may you illustrate
thanks

5 answers ( 2 marked as helpful)
Posted on:

18 Nov 2022

0

Try running the query with and without the minus sign, then compare the result sets. it should be pretty clear then what it is doing, though i'm not sure why the chose to demonstrate that here...

Posted on:

18 Nov 2022

0

Thanks Nicholas Burmeister

Instructor
Posted on:

18 Nov 2022

0

Hi Islam!
Thanks for reaching out.

It simply reverts the order in which your output will be displayed. The null values have precedence.

Hope this helps.
Best,
Tsvetelin

Posted on:

18 Nov 2022

0

Tsvetelin Tsonkov
Thanks for your continuing support 🌷

Posted on:

14 Dec 2022

0

Also ordering by -a.emp_no desc is better than ordering by a.emp_no asc as the first one does not display null values first but the second one does

Submit an answer