The ORDER BY keyword is used to sort the result.

Sort the Rows

The ORDER BY clause is used to sort the rows.

Orders:

Example

To display the companies in alphabetical order:

SELECT Company, OrderNumber FROM Orders
ORDER BY Company

Result:

Example

To display the companies in alphabetical order AND the ordernumbers in numerical order:

SELECT Company, OrderNumber FROM Orders
ORDER BY Company, OrderNumber

Result:

Example

To display the companies in reverse alphabetical order:

SELECT Company, OrderNumber FROM Orders
ORDER BY Company DESC

Result:

Example

To display the companies in reverse alphabetical order AND the ordernumbers in numerical order:

SELECT Company, OrderNumber FROM Orders
ORDER BY Company DESC, OrderNumber ASC

Result: