Question

SQL统计记录、计算总和

各位大神，小弟在此求助：现有表A和表B，用SQL语句如何才能实现如图一所示的效果？





Answer 1

select SUM([需要求和的字段名称]) from [要求和的表名]也可以在后面附加限制条件如： where [日期] > 'XXXX-XX-XX' and [日期] <= 'XXXX-XX-XX'

Answer 2

select a.id,name,sex,phone,depart,count(distinct b.target) as count_target,sum(b.figure) as sum_target from a,b where a.id=b.id group by a.id,name,sex,phone,depart