颤抖吧,骚年们,2016年末最牛逼的sql语句
摘要:
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 阅读全文
posted @ 2016-12-19 20:09 防空洞123 阅读(666) 评论(0) 推荐(0) 编辑