You can sort query results by more than one column. The sort limit is the number of columns in the given table.
In the ORDER BY clause, specify the columns, and separate the column names using commas. If you want to reverse the order of a column, specify DESC after its name. You can also order by columns that are not included in the SELECT clause.
Example
Display the last names and salaries of all employees. Order the result by department number, and then in descending order by salary.
SELECT last_name, salary FROM employees ORDER BY department_id, salary DESC;