关闭

排序精典,不得不看~

794人阅读 评论(0) 收藏 举报

declare @t table(id int,Uid int,Str varchar(4))
insert into @t select 1,5,'aaa'
insert into @t select 2,5,'bbb'
insert into @t select 3,5,'ccc'
insert into @t select 4,6,'ddd'
insert into @t select 5,6,'eee'
insert into @t select 6,8,'ggg'
insert into @t select 7,8,'ttt'
insert into @t select 8,2,'uuu'
insert into @t select 9,2,'hhh'

select a.* from @t a order by (select count(*) from @t where Uid=a.Uid and id<=a.id),uid

/*
id          Uid         Str 
----------- ----------- ----
8           2           uuu
1           5           aaa
4           6           ddd
6           8           ggg
9           2           hhh
2           5           bbb
5           6           eee
7           8           ttt
3           5           ccc
*/

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:260293次
    • 积分:2969
    • 等级:
    • 排名:第11810名
    • 原创:62篇
    • 转载:53篇
    • 译文:0篇
    • 评论:50条
    最新评论