表为:
Userid UserName ...
1 WU
2 Peng
3 WU
4 Jiang
5 Jiang
6 WU
7 Peng
8 Shi
...需要排列后的结果为:
1 WU
3 WU
6 WU
2 Peng
7 Peng
4 Jiang
5 Jiang
8 Shi 即要UserName相同显示一起,同时要按UserID的升序排.
Userid UserName ...
1 WU
2 Peng
3 WU
4 Jiang
5 Jiang
6 WU
7 Peng
8 Shi
...需要排列后的结果为:
1 WU
3 WU
6 WU
2 Peng
7 Peng
4 Jiang
5 Jiang
8 Shi 即要UserName相同显示一起,同时要按UserID的升序排.
t.*
from
表 t
order by
(select count(*) from 表 where UserName=t.UserName),t.UserName,t.Userid
t.*
from
表 t
order by
(select count(*) from 表 where UserName=t.UserName) desc,t.UserName,t.Userid
??
不知道讲清楚没有
insert into @a select 1,'wu' union all
select 2,'peng' union all
select 3,'wu' union all
select 4,'jiang' union all
select 5,'jiang' union all
select 6,'wu' union all
select 7,'peng' union all
select 8,'shi'
select * from @a group by username,userid order by username desc
3 WU
6 WU
2 Peng
7 Peng
...
insert into @a select 1,'wu' union all
select 2,'peng' union all
select 3,'wu' union all
select 4,'jiang' union all
select 5,'jiang' union all
select 6,'wu' union all
select 7,'peng' union all
select 8,'shi'
select * from @a group by username,userid order by username,userid
select
t.*
from
表 t
order by
(select min(Userid) from 表 where UserName=t.UserName) desc,t.UserName,t.Userid
而且就现在结果也是错误的!
t.*
from
表 t
order by
(select min(Userid) from 表 where UserName=t.UserName),t.Userid