34,588
社区成员
发帖
与我相关
我的任务
分享
select count(zhuid),
sum(case fuid when 1 then 1 else 0 end),
sum(case fuid when 2 then 1 else 0 end),
from [user] group by zhuid
select
count(zhuid),
sum(case fuid when 1 then 1 else 0 end),
sum(case fuid when 2 then 1 else 0 end),
from
[user]
select
count(zhuid),
sum(case fuid when 1 then 1 else 0 end),
sum(case fuid when 2 then 1 else 0 end),
from [user]
select count(zhuid),count(fuid),count(sid) from user