|
select ?cc.fName,
count(CASE ?aa.fInfoResource WHEN ?'市场活动' THEN aa.fId END ) AS '市场活动',
count(CASE ?aa.fInfoResource WHEN ?'老师推荐' THEN aa.fId END ) AS '老师推荐',
count(CASE ?aa.fInfoResource WHEN ?'学员推荐' THEN aa.fId END ) AS '学员推荐',
count(CASE ?aa.fInfoResource WHEN ?'网站客服' THEN aa.fId END ) AS '网站客服',
count(CASE ?aa.fInfoResource WHEN ?'户外广告' THEN aa.fId END ) AS '户外广告',
count(CASE ?aa.fInfoResource WHEN ?'简章传单' THEN aa.fId END ) AS '简章传单',
count(CASE ?aa.fInfoResource WHEN ?'电话' THEN aa.fId END ) AS '电话',
count(CASE ?aa.fInfoResource WHEN ?'QQ' THEN aa.fId END ) AS 'QQ'
FROM t_ClueInfo aa?
left join S_BaseItem bb on aa.fInfoResource = bb.fName?
left join S_Department cc on aa.fDepartment = cc.fId ? GROUP BY cc.fName
case部分代码动态产生
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
