求一个SQL语句!!!!!!!!!!!!!!!!!!!!!!
有一张表
------------
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;