日期:2014-05-19  浏览次数:20407 次

大哥们,列循环问题,急啊!
字段:
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