求一sql语句 行转列

Question

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语句？