ORDERING DATA

Question 1

ORDER BY

Answer 1

Orders the column in descending and ascending(default) order.
Text are in alphabetical and number in smallest first.

SELECT column
FROM data
ORDER BY column;

Question 2

ASC

Answer 2

Keyword used in order by ascending order.
SELECT column
FROM data
ORDER BY column ASC;

Question 3

DESC

Answer 3

Keyword used in order in descending order.

SELECT column
FROM data
ORDER BY column DESC;