来看个sql:
select id, title, album_uuid from video
where class_id = 8 AND STATUS = 9 AND deleted = 0
GROUP BY album_uuid
ORDER BY online_time desc limit 4;
结果:
结果不符合我想要的要求,因为这里把album_uuid等于null的都聚合到一起了。
我们可以使用**IFNULL()**函数对album_uuid的数据进行替换id对null值进行替换(注意:这里我看其他博主使用的是UUID()函数生成随机值进行替换,但是我这么操作得到的值都是一样的):
select id,title, album_uuid from video
where class_id = 8 AND STATUS = 9 AND deleted = 0
GROUP BY IFNULL(album_uuid, id)
ORDER BY online_time desc limit 4;