SQL ORDER BY
After being learn through all the displaying data syntax. Itís time to learn how to sort data by using ORDER BY.
Yes it is. ORDER BY clause allows you to sort the records in your result set. This clause can only be used in SELECT statements. The ORDER BY clause sorts the result set based on the columns specified by ASC or DESC value is stated. If not the system assumed the sorting is ascending order.
Let's see on the syntax:
SELECT [COLUMN NAME] FROM [TABLE NAME] ORDER BY [COLUMN 1]
ASC indicates ascending order. (This value is default sorting for SQL syntax)
let's see some simple sorting from the SQL statement using ORDER BY SQL statement :
SELECT * FROM GameScores ORDER BY Scores
Result will be the same if the SQL statement write like this :
SELECT * FROM GameScores ORDER BY Scores ASC
let's see the example of sorting by DESC (descending order)
SELECT * FROM GameScores ORDER BY Scores DESC