大哥们,列循环问题,急啊!
字段:
aa
1
2
3
4
5
6
7
8
9
10
11
12
13
要求显示的是
aa1 aa2 aa3 aa4 aa5
1 2 3 4 5
6 7 8 9 10
11 12
菜鸟小弟谢谢了
------解决方案--------------------try
Select
Max(Case (aa - 1) % 5 When 0 Then aa Else 0 End) As aa1,
Max(Case (aa - 1) % 5 When 1 Then aa Else 0 End) As aa2,
Max(Case (aa - 1) % 5 When 2 Then aa Else 0 End) As aa3,
Max(Case (aa - 1) % 5 When 3 Then aa Else 0 End) As aa4,
Max(Case (aa - 1) % 5 When 4 Then aa Else 0 End) As aa5
From
表
Group By
(aa - 1) / 5