？？？统计数量

[kekemethod2]

select * from MobileInfo

这张表的数据

SELECT COUNT(CASE flag WHEN 0 THEN 0 WHEN 1 THEN 0 WHEN 2 THEN 0 WHEN 3 THEN 0 END) AS Totalumber,
COUNT(CASE flag WHEN 0 THEN 0 END) AS Xnumber, COUNT(CASE flag WHEN 1 THEN 0 END) AS Lnumber,
COUNT(CASE flag WHEN 2 THEN 0 END) AS Ynumber, COUNT(CASE flag WHEN 3 THEN 0 END) AS Cnumber, GroupName
FROM MobileInfo where CorpID='HT00001'and GroupID=850 GROUP BY GroupName
当groupID=850 得到的数据


现在MobileInfo 多咯FatherID这一列 怎么统计呀 界面上是树 点击父节点能获得当前父节点和下面的子节点的值


850 下面有两个节点868和870
SELECT COUNT(CASE flag WHEN 0 THEN 0 WHEN 1 THEN 0 WHEN 2 THEN 0 WHEN 3 THEN 0 END) AS Totalumber,
COUNT(CASE flag WHEN 0 THEN 0 END) AS Xnumber, COUNT(CASE flag WHEN 1 THEN 0 END) AS Lnumber,
COUNT(CASE flag WHEN 2 THEN 0 END) AS Ynumber, COUNT(CASE flag WHEN 3 THEN 0 END) AS Cnumber, GroupName
FROM MobileInfo where CorpID='HT00001'and GroupID in(850,868,870) GROUP BY GroupName
我这样写得到的结果是


我想要的结果是 一条数据

108+8+8 ，9+1+0，，，，，GropName是父节点组别名：2分组

[ljhcy99]

为什么总是看不到图片~

[kekemethod2]

不会哦