34,590
社区成员
发帖
与我相关
我的任务
分享
create table YangYun
(ID int,UserName char(6), CardNO int, EndDate date)
insert into YangYun
select 1, '张三', 10004, '2012-4-20' union all
select 2, '李四', 10005, '2012-3-20' union all
select 3, '张三', 10004, '2012-5-20' union all
select 4, '张三', 10004, '2014-5-20' union all
select 5, '李四', 10005, '2014-5-20'
select *
from YangYun
order by CardNO,EndDate
ID UserName CardNO EndDate
----------- -------- ----------- ----------
1 张三 10004 2012-04-20
3 张三 10004 2012-05-20
4 张三 10004 2014-05-20
2 李四 10005 2012-03-20
5 李四 10005 2014-05-20
(5 row(s) affected)
select ID,UserName,CardNO,EndDate from tb order by CardNo,EndDate