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
舉報
2018-08-01
instr不是組函數吧
2017-04-25
having的后面不可以有組函數吧