sql统计

[shiqiang723]

我需要将name=工学的count等于它所有子类count的和.

select c.title as [name],c.id,c.Parent,
(select count(v.id) from videoIPList v where v.class = c.id 
and v.addTime<='2018/3/20 9:56:56'
 AND ((v.schoolId=178 and v.iplistid in(select id from IPList where schoolid=178
)) or v.userid=-999) and v.addTime >='2011-1-1' and 
v.addTime<='2018-3-31 23:59:59' and v.addTime<='2018/3/20 9:56:56') as [count]
from tsys_Class c 
order by c.id

[正怒月神]

select count(1) from 表 where parentid=43

[shoppo0505]

update 表格 set count = (select count(*) from 表格 where parent = 43) where id = 43