sql语句 - 请教关于mysql分组查询统计数据的问题

Answer 1

自己找到答案了。参考了这里
http://blog.csdn.net/swweb/ar...

核心语句修改如下：

SELECT `task_id`, MAX(`send_time`) AS `day` FROM `game_work` GROUP BY `task_id` ORDER BY `day` DESC

Answer 2

从表名中选择 sum(num) 作为 num, task_id, day group by day task_id order by day desc limit 1,30