sql语句 - 请教关于mysql分组查询统计数据的问题
黄舟
黄舟 2017-04-17 16:23:43
0
2
653
黄舟
黄舟

人生最曼妙的风景,竟是内心的淡定与从容!

reply all (2)
洪涛

自己找到答案了。参考了这里
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

      Latest Downloads
      More>
      Web Effects
      Website Source Code
      Website Materials
      Front End Template
      About us Disclaimer Sitemap
      php.cn:Public welfare online PHP training,Help PHP learners grow quickly!