ORACLE分组查询,如果有一个字段需要用逗号隔开 SELECT wm_concat (PAY_PLAN_NO), GROUP_CODE, GROUP_CNAME FROM FM_PAYMENT_PLAN_MAIN GROUP BY GROUP_CNAME, GROUP_CODE