Find name and marks of all students with their respective marks in descending order.
We can add
DESC to the name of the column in
ORDER BY clause to achieve this.
DESC is the SQL syntax equivalent of
Similarly, to sort the same data in ascending order, we can add
ASC to the name of the column in
ASC is optional, as the default order of sorting in SQL is
ascending, unless specified explicitly.