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;

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

ASC

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

DESC

A

Keyword used in order in descending order.

SELECT column
FROM data
ORDER BY column DESC;

How well did you know this?
1
Not at all
2
3
4
5
Perfectly