有一张表
------------
id name
------------
1 aa
1 bb
1 cc
2 aa
2 bb
2 cc
然后我想用GROUP BY 分组只显示两条记录
1 aa bb cc
2 aa bb cc
这条SQL怎么写?
------解决方案--------------------
- SQL code
SELECT ID, MAX(DECODE(NAME, 'aa', 'aa' )) aa, MAX(DECODE(NAME, 'bb', 'bb' )) bb, MAX(DECODE(NAME, 'cc', 'cc' )) cc FROM tt GROUP BY ID;