ORDER BY Keyword in SQL Server

ORDER BY Keyword in SQL Server

The ORDER BY keyword sorts the records in ascending order by default. To sort the records in descending order, use the DESC keyword

Syntax ORDER BY

SELECT column1, column2,column3, ........
FROM table_name
ORDER BY column1, column2,column3, ... ASC|DESC
SELECT * FROM Customers
ORDER BY Country ASC
SELECT * FROM Customers
ORDER BY Country DESC
SELECT * FROM Customers
ORDER BY Country

2020-03-27