ORDER BY clause sorts the results in ascending or descending order. By default, it sorts the results in ascending order, or the ASC keyword can also be provided explicitly. The use of the DESC keyword will order the records in descending order. The syntax is given by –  ORDER BY [column name] ASC|DESC We can also sort the records with respect to multiple columns, for example sorting the records by name in ascending order and marks in descending order –  SELECT *
FROM students
ORDER BY name ASC, score DESC;