ORDERING DATA Flashcards
1
Q
ORDER BY
A
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;
2
Q
ASC
A
Keyword used in order by ascending order.
SELECT column
FROM data
ORDER BY column ASC;
3
Q
DESC
A
Keyword used in order in descending order.
SELECT column
FROM data
ORDER BY column DESC;