ORDER BY dm.dept_no DESC, e.emp_no;

in SQL / LEFT JOIN - Part II

what does the e.emp_no means that show after the DESC?

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

14 Jul 2022

Hi I-Cheng!
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.
Best,
Tsvetelin

Submit an answer

related questions

Ramsey Alizadeh

SQL’s Order Of Execution

Meenakshi Akila P.S

using aliases in order by clause

Shekhar Tanwar

Resolved: How can we have result from below query (Count(First_name) in ascending / descending order ?

Asmaa Abdulhamid

Where is the logic in using COUNT(from_date) > 1 in order to count contracts number????

Saeed Ehsanfar

Resolved: Any difference if changing the order of the tables around CROSS JOIN

Abdul Hakeem

Resolved: The sequence is always WHERE, GROUP BY, HAVING and Order BY

Sam Parker

What does the minus sign ( – ) mean in ORDER BY –a.emp_no DESC;

Ayush Sahu

Resolved: confusion using group by and order by