扫码关注官方订阅号
人生最曼妙的风景，竟是内心的淡定与从容！
自己找到答案了。参考了这里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
微信扫码关注PHP中文网服务号
QQ扫码加入技术交流群
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
PHP学习
技术支持
返回顶部
0 
2
947
收藏
自己找到答案了。参考了这里
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