存在以下一个表
select 0,1
union select 0,2
union select 0,3
union select 0,4
union select 1,0
union select 2,0
union select 3,0
union select 4,0
排序后要求变成
0,1
1,0
0,2
2,0
0,3
3,0
0,4
4,0该怎么样做啊?感觉不可能实现阿
select 0,1
union select 0,2
union select 0,3
union select 0,4
union select 1,0
union select 2,0
union select 3,0
union select 4,0
排序后要求变成
0,1
1,0
0,2
2,0
0,3
3,0
0,4
4,0该怎么样做啊?感觉不可能实现阿
Select * from (
select 0 as ID1,1 as ID2
union select 0,2
union select 0,3
union select 0,4
union select 1,0
union select 2,0
union select 3,0
union select 4,0) as t
order by ID1+ID2,ID1
insert T select 0, 1
union select 0,2
union select 0,3
union select 0,4
union select 1,0
union select 2,0
union select 3,0
union select 4,0select * from T
order by (case when col1=0 then col2 else col1 end), col2 desc--result
col1 col2
----------- -----------
0 1
1 0
0 2
2 0
0 3
3 0
0 4
4 0(8 row(s) affected)