select `code`,sum((0.5-payflag)*2*pay) from table group by `code`
SELECT `code`,SUM(IF(payflag=0,pay,0))-SUM(IF(payflag=1,pay,0)) AS pay FROM `tablename` GROUP BY `code`
56,687
社区成员
56,710
社区内容
加载中
试试用AI创作助手写篇文章吧