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)
DESC indicates descending order.


EXAMPLE#1 :

Table GameScores

PlayerNameDepartmentScores
JasonIT3000
IreneIT1500
JaneMarketing1000
DavidMarketing2500
PaulHR2000
JamesHR2000

let's see some simple sorting from the SQL statement using ORDER BY SQL statement :

SELECT * FROM GameScores ORDER BY Scores

Result:

PlayerNameDepartmentScores
JaneMarketing1000
IreneIT1500
PaulHR2000
JamesHR2000
DavidMarketing2500
JasonIT3000

Result will be the same if the SQL statement write like this :

SELECT * FROM GameScores ORDER BY Scores ASC


EXAMPLE#2 :

let's see the example of sorting by DESC (descending order)
SQL statement :

SELECT * FROM GameScores ORDER BY Scores DESC

Result:

PlayerNameDepartmentScores
JasonIT3000
DavidMarketing2500
PaulHR2000
JamesHR2000
IreneIT1500
JaneMarketing1000