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)
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...
Thanks Nicholas Burmeister
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
Tsvetelin Tsonkov
Thanks for your continuing support 🌷
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