CREATE TABLE `log_addmoney` (
`paysn` varchar(20) NOT NULL,
`uid` int(11) NOT NULL,
`roleid` int(11) NOT NULL,
`money` int(11) NOT NULL,
`isfirst` tinyint(4) NOT NULL,
`unixtime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`moneycat` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 PACK_KEYS=0;
如何再追加一列,就是每天的 isfirst=1的总数select Date(unixtime) as dt,SUM(money) ,count(*) as num from log_addmoney group by dt order by dt;
这个查询出来的是 日期,充值总数,充值人数,现在需要统计该天的首冲人数。谢谢
SELECT DATE(unixtime) AS dt,SUM(money) ,COUNT(*),SUM(IF(isfirst=1,1,0)) AS 首冲人数 AS num FROM log_addmoney GROUP BY dt ORDER BY dt;
sum(case when isfirst=1 then 1 else 0 end)
from log_addmoney
group by dt order by dt;