查询结果如下
packid colorid
1 1
1 2
1 3
1 4
1 5
2 1
2 2
2 3
2 4
2 5如何得到如下的结果
colorid packid
1 1
1 2
2 1
2 2
3 1
3 2
4 1
4 2
5 1
5 2
packid colorid
1 1
1 2
1 3
1 4
1 5
2 1
2 2
2 3
2 4
2 5如何得到如下的结果
colorid packid
1 1
1 2
2 1
2 2
3 1
3 2
4 1
4 2
5 1
5 2
order by colorid,packid
Select
CountID / 2 As packid,
CountID % 2 + 1 As colorid
From
(Select *, CountID = (Select Count(*) From TEST Where packid < A.packid Or (packid = A.packid And colorid < A.colorid)) + 2 From TEST A) B