如何使用sum函数求正数和与负数和各位下午好: 请问如何用sum函数求一个字段的正数和与负数和,谢谢!![解决办法]select sum(case when column> 0 then column else 0 end) as u0, sum(case when column <0 then column else 0 end ) as d0 from tablename