有没有大佬知道是什么问题 报错ora00937不是单组分组函数select
tt.cc,
sum(case when tt.name='安全' then sum(tt.userid) else 0 end)
from
(select t.*,c.name,d.name cc
from t_login_answer_log t
left join pf_org_user u on t.userid=u.id
left join pf_org_department d on d.id=u.dept_id
left join t_login_lib lib on t.libid=lib.id
left join t_login_category c on lib.category=c.id) tt
group by tt.cc
tt.cc,
sum(case when tt.name='安全' then sum(tt.userid) else 0 end)
from
(select t.*,c.name,d.name cc
from t_login_answer_log t
left join pf_org_user u on t.userid=u.id
left join pf_org_department d on d.id=u.dept_id
left join t_login_lib lib on t.libid=lib.id
left join t_login_category c on lib.category=c.id) tt
group by tt.cc
select
v.cc,sum(bb)
from
(select
tt.cc,
case when tt.name='安全' then sum(tt.userid) else 0 end bb
from
(select t.*,c.name,d.name cc
from t_login_answer_log t
left join pf_org_user u on t.userid=u.id
left join pf_org_department d on d.id=u.dept_id
left join t_login_lib lib on t.libid=lib.id
left join t_login_category c on lib.category=c.id) tt
group by tt.cc
)v你這樣試一下
sum(tt.userid) ,这是要做什么呢?
因为需要得到userid的数量
因为需要得到userid的数量
那你这里把第一个sun改成count第二个去掉,然后else后面的0改成null
因为需要得到userid的数量
那你这里把第一个sun改成count第二个去掉,然后else后面的0改成null
nb呀,大佬万分感谢