a:使用:Count(表达式 Or null)
b:使用:Count(Case when 表达式 then 1 END) 或者 Count(CASE WHEN 表达式 THEN 1 ELSE null END)
如:
select userid, COUNT(ParentID=0 OR NULL), COUNT(CASE WHEN ParentID=0 THEN 1 END), COUNT(CASE WHEN ParentID=0 THEN 1 ELSE NULL END) from usermessage where userid in (511946,656015,1541157,3465768,5049530,5112483,5210074,5372797) GROUP BY userid