求一sql语句 行转列

[xjis00]

COL1 COL2 COL3 COL4
----------------------------
表里面得内容为：
COL1 COL2 COL3 COL4
----------------------------
A B 1 125
A B 2 250
A B 3 330
A B 4 440
A B 5 570
........

现在要显示为
COL1 COL2 COL3 COL4 COL5 COL6 COL7 .....
------------------------------------------------------------
A B 1 125 250 330 440 ....

总之是COL1和COL2 相等的 都显示在一行上面 怎么写这样的sql语句？

[mittee]

写挺麻烦的，
用交叉表行不？

[ghost34]

sql写个交叉表.

[jxc]

写死的语法:

select col1,col2
,max((select sum(b.col4) from test b where b.col1=a.col1 and b.col2=a.col2 and b.col3 = '1')) c1
,max((select sum(b.col4) from test b where b.col1=a.col1 and b.col2=a.col2 and b.col3 = '2')) c2
,max((select sum(b.col4) from test b where b.col1=a.col1 and b.col2=a.col2 and b.col3 = '3')) c3
,max((select sum(b.col4) from test b where b.col1=a.col1 and b.col2=a.col2 and
b.col3 = '4')) c4
,max((select sum(b.col4) from test b where b.col1=a.col1 and b.col2=a.col2 and b.col3 = '5')) c5
from test a
group by col1,col2
/

[紫炎圣骑]

用交叉表比较方便的！

[kirao]

建議你用pb的交叉報表!