求一个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;