Sort the Rows in SQL

Advertisements

This article is based on the ORDER BY clause in SQL query, which is used to sort the result. The ORDER BY clause is used to sort the rows.

Syntax:
SELECT column1, column2 … FROM tableName WHERE <condition> ORDER BY <columnName>

Query is:

SELECT Company , OrderNumber FROM tbl_Orders

Result  not using ORDER BY clause