結果是出來了，但不知是否有BUG，總感覺哪里有問題
col 課程號 format a5
col 選課名單 format a20
select c.ci_id 課程號,wm_concat(s.stu_name) 選課名單
from pm_ci c,pm_stu s
where instr(c.stu_ids,s.stu_id)>0
group by c.ci_id;
踏破鐵鞋無覓處，驀然回首，答案就在燈火闌珊處
C_plus
2018-07-15
1 回答
舉報
0/150
提交
取消
2018-08-17
select p.ci_id,max(stu_name) as STU_NAME
from (select c.ci_id,wm_concat(s.stu_name)?
over(partition BY c.stu_ids order by s.stu_id) as stu_name
from pm_ci c,pm_stu s
where instr(c.stu_ids,s.stu_id) > 0) p?
group by p.ci_id
查詢出來后有排序效果的..