示例:select count(*) as newclo1,sum(if(col2>0,1,0)) as newclo2,
sum(if(col3>0,1,0)) as newclo3
from tt group by col1
可以根据不同字段的信息 统计显示信息
示例:select count(*) as newclo1,sum(if(col2>0,1,0)) as newclo2,
sum(if(col3>0,1,0)) as newclo3
from tt group by col1
可以根据不同字段的信息 统计显示信息