您现在的位置是：首页 > 文章详情

MSSQL sql server order by 1,2 的具体含义

日期：2018-07-16点击：463收藏

转自:http://www.maomao365.com/?p=5416

摘要:
order by 1,2 的含义是对表的第一列按照从小到大的顺序进行排列

然后再对第二列按照从小到大的顺序进行排列

order by 1,2 等同于 order by [第一列],[第二列]

详见以下举例说明

create table A (keyId varchar(20),name varchar(120)) go insert into A (name,keyId)values(10,'we') insert into A (name,keyId)values(2,'b') insert into A (name,keyId)values(3,'C') insert into A (name,keyId)values(4,'a') insert into A (name,keyId)values(5,'E') insert into A (name,keyId)values(7,'F') go select * from A go select * from A order by 1,2 go truncate table A drop table A go