The specific meaning of MSSQL SQL Server order BY

Transferred from: http://www.maomao365.com/?p=5416

Summary:
Order by means that the first column of the table is arranged in order from small to large

Then arrange the second column in order from small to large

Order BY is equivalent to order BY [first column],[second column]

See the examples below for more information

Create TableA (keyIdvarchar( -), namevarchar( -))GoInsert  intoA (Name,keyid)Values(Ten,'We')Insert  intoA (Name,keyid)Values(2,'b')Insert  intoA (Name,keyid)Values(3,'C')Insert  intoA (Name,keyid)Values(4,'a')Insert  intoA (Name,keyid)Values(5,'E')Insert  intoA (Name,keyid)Values(7,'F')GoSelect *  fromAGoSelect *  fromAOrder  by  1,2 Gotruncate TableADrop TableAGo 

The specific meaning of MSSQL SQL Server order BY