mysql - 按条件统计

在表中分别统计mt =0 和 mt>0 的个数

方法一:select count(if(mt=0,1,null)) as a,count(if(mt>0,1,null)) as b from table

方法二:select sum(mt=0) as a,sum(mt>0) as b from table

 

posted @ 2019-01-31 11:39  Hitechr  阅读(3225)  评论(0编辑  收藏  举报