我会尝试这样的事情：
SELECt s.video_id ,s.video_category ,s.video_url ,s.video_date ,s.video_title ,short_descriptionFROM videos s JOIN (SELECt MAX(video_id) AS id FROM videos GROUP BY video_category) max ON s.video_id = max.id
这比您自己的解决方案要快得多
我会尝试这样的事情：
SELECt s.video_id ,s.video_category ,s.video_url ,s.video_date ,s.video_title ,short_descriptionFROM videos s JOIN (SELECt MAX(video_id) AS id FROM videos GROUP BY video_category) max ON s.video_id = max.id
这比您自己的解决方案要快得多
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
