4. ORDER BY to display data in ascending / descending order.

 

SQL

-- Display students in ascending order by age

SELECT * FROM Student ORDER BY age ASC;

 

-- Display students in descending order by name

SELECT * FROM Student ORDER BY name DESC;