求sql语句

Question

pln_id memo 
  1     我是
  1     你好
  2     你是
  2     我好  结果  pln_id memo  
     1  我是你好
     2  你是我好

Answer 1

SQL> select * from t;                                    IDX NAME
--------------------------------------- ----------------------------------------
                                      1 我是
                                      1 神仙
                                      2 我是
                                      2 神仙SQL> 
SQL> select idx,replace(wmsys.wm_concat(name),',','') name from t
  2  group by idx;                                    IDX NAME
--------------------------------------- --------------------------------------------------------------------------------
                                      1 我是神仙
                                      2 我是神仙SQL> 

Answer 2

lz意思应该就是按pln_id分组。

Answer 3

参照：
http://topic.csdn.net/u/20091009/16/2f2e4fbc-3158-4720-8134-f5c260d314d3.html