ORDER BY dm.dept_no DESC, e.emp_no;
what does the e.emp_no means that show after the DESC?
Thanks for reaching out.
This means that it is the second column in the ORDER BY clause. When the order of sorting is not specified, this means that the order is ascending. For example:
ORDER BY column_1;
is the same as
ORDER BY column_1 ASC;
Hope this helps.