select channel_name,from_unixtime(createTime,'%Y-%m-%d') as tdate,count(deviceid) '安装量',count(case when amt<>0 then 1 end) '付费量' from v_payitem group by channel_name,tdate
count里可以加条件判断,你们见过吗?
posted on 2016-12-19 20:09 防空洞123 阅读(666) 评论(0) 编辑 收藏 举报