mysql使用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
参考链接:http://www.myexceptions.net/sql-server/164695.html
mysql使用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
参考链接:http://www.myexceptions.net/sql-server/164695.html