sql查询语句,同一个条件,返回多个结果答:如果是Oracle的话,用Decode函数比较简洁 -- type作为查询条件进行查询select sum(decode(type, 'project', money, 'nonproject', money+tax))from contract where type='type值';-- 不传值,直接汇总select sum(decode(type, 'project', money, 0)) as project_sum, sum(decode(type, 'non...