mysql GROUP BY 获取最新的一条记录

最新推荐文章于 2024-09-19 06:04:45 发布

原创最新推荐文章于 2024-09-19 06:04:45 发布 · 1.5k 阅读

0 ·

CC 4.0 BY-SA版权

mysql 专栏收录该内容

4 篇文章

订阅专栏

SELECT lw.id,
            lw.uid,
            lw.title,
			SUM(lwl.voice_num) as voice_num,
			lwl.title AS lists_title,
			lwl.created_at,lw.is_finished,lw.collect_num FROM
			(SELECT * FROM a WHERE pid != 0 ORDER BY created_at DESC LIMIT 10000) as lwl
            LEFT JOIN b as lw ON lw.uid = lwl.work_id 
            GROUP BY lw.uid

mysql5.7如果不用limit限制ORDER BY不生效