Question

sql 统计查询中如何根据某bool字段的值决定int字段值的增或减

用sum()进行某int字段的统计，bool字段值为1时，int字段加，否则int字段减，比如某表有贷和借两个模式，通过判断贷或借来决定金额是增加还是减少
自己解决了
sql:
select sum(case when mode = 0 then 0-counts else counts) from .....
access:
select sum(iif(mode=0,0-counts,counts) from .....

Answer 1

SELECT sum(CASE WHEN boolField IS TRUE THEN 1 ELSE -1 END) FROM table;
先这样查出加减的总和，然后再和“某int字段”相加，你看这样行不行？

Answer 2

select case when bool='1' then int1+int2 else int1-int2 end as 'int' from 表