Question

用SQL语句对数据库某字段进行求和，求和条件怎么写？

Answer 1

select sum（xsl）as yxsl,
id , to_char(date,'yyyymm') as month
from 表名 where year=$year

group by id,to_char(date,'yyyymm')

按id和月份分组