这个是oracle我想查询每个月的总金额
SELECT TO_CHAR(ZTIME,'yyyy-MM'),SUM(SALE_AMOUNT) [SUM_] FROM TABLE GROUP BY TO_CHAR(ZTIME,'yyyy-MM') 试试
sum(字段)
group by to_char(ztime,'yyyy-MM')
SELECT substr(ztime,1,7) as 月份 ,sum(sale_amount) as 总金额 from table group by substr(ztime,1,7)