84669 person learning
152542 person learning
20005 person learning
5487 person learning
7821 person learning
359900 person learning
3350 person learning
180660 person learning
48569 person learning
18603 person learning
40936 person learning
1549 person learning
1183 person learning
32909 person learning
人生最曼妙的风景,竟是内心的淡定与从容!
自己找到答案了。参考了这里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
select sum(num) as num, task_id, day from tablename group by day task_id order by day desc limit 1,30
自己找到答案了。参考了这里
http://blog.csdn.net/swweb/ar...
核心语句修改如下:
select sum(num) as num, task_id, day from tablename group by day task_id order by day desc limit 1,30