wm_concat 不是組函數(shù)么?為什么這里要用where,而不是having?
select c.ci_id,wm_concat(s.stu_name)
from pm_ci c,pm_stu s
having instr(c.stu_ids,s.stu_id)>0
group by c.ci_id;
select c.ci_id,wm_concat(s.stu_name)
from pm_ci c,pm_stu s
having instr(c.stu_ids,s.stu_id)>0
group by c.ci_id;
2017-04-22
舉報(bào)
2018-08-01
instr不是組函數(shù)吧
2017-04-25
having的后面不可以有組函數(shù)吧