select userid ,sum(score) from tt group by userid where FROM_UNIXTIME(1311842696) between '2011-7-28 16:00:00' and '2011-7-28 16:44:56'
select userid ,sum(score) from tt where FROM_UNIXTIME(1311842696) between '2011-7-28 16:00:00' and '2011-7-28 16:44:56' group by userid
select userid ,sum(score) from tt group by userid where FROM_UNIXTIME(1311842696) between '2011-7-28 16:00:00' and '2011-7-28 16:44:56' group by userid 上面少了group by userid
select userid ,sum(score) from 有一个日志表 where FROM_UNIXTIME(adddate) between '2011-01-01 08:00:00' and '2011-08-01 18:00:00' group by userid
between '2011-7-28 16:00:00' and '2011-7-28 16:44:56'
select userid ,sum(score) from tt where FROM_UNIXTIME(1311842696)
between '2011-7-28 16:00:00' and '2011-7-28 16:44:56' group by userid
between '2011-7-28 16:00:00' and '2011-7-28 16:44:56' group by userid
上面少了group by userid
from 有一个日志表
where FROM_UNIXTIME(adddate) between '2011-01-01 08:00:00' and '2011-08-01 18:00:00'
group by userid