結(jié)果是出來(lái)了，但不知是否有BUG，總感覺(jué)哪里有問(wèn)題
col 課程號(hào) format a5
col 選課名單 format a20
select c.ci_id 課程號(hào),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;
踏破鐵鞋無(wú)覓處，驀然回首，答案就在燈火闌珊處
C_plus
2018-07-15
1 回答
舉報(bào)
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
查詢出來(lái)后有排序效果的..