本文通过 SQL 查询展示了一种按年份分组并统计未确认与已确认支付金额的方法。该查询从农业数据表中筛选出一级的数据，分别计算每年的支付总额及已付款总额。
SELECT ptime,SUM(paying)AS paying ,SUM(payed)AS payed FROM
(SELECT YEAR(paytime)AS ptime,CASE WHEN confirm=0 THEN amount ELSE 0 END AS paying ,
CASE WHEN confirm=1 THEN amount ELSE 0 END AS payed
FROM agriculture WHERE `level`=1 ) aa
GROUP BY ptime
(SELECT YEAR(paytime)AS ptime,CASE WHEN confirm=0 THEN amount ELSE 0 END AS paying ,
CASE WHEN confirm=1 THEN amount ELSE 0 END AS payed
FROM agriculture WHERE `level`=1 ) aa
GROUP BY ptime
扫一扫
1130
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
