wm_concat 不是组函数么？为什么这里要用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;
2 回答
举报
0/150
提交
取消
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
举报
