有一张表
------------
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怎么写?
------------
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怎么写?
MAX(DECODE(NAME, 'aa', 'aa' )) aa,
MAX(DECODE(NAME, 'bb', 'bb' )) bb,
MAX(DECODE(NAME, 'cc', 'cc' )) cc
FROM tt GROUP BY ID;
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;楼上正确