sql語句 - 請教關于mysql分組查詢統計數據的問題

問題描述

問題解答

自己找到答案了。參考了這里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回答2：

select sum(num) as num, task_id, day from tablename group by day task_id order by day desc limit 1,30