mysql5.7*分组排序 取最新的一条
发表于:2022-02-10 10:44:33浏览:1769次
select a.* from ( SELECT * FROM open_data_co ORDER BY id DESC //里面使用limit固定排序 LIMIT 1000 ) a group by a.id //最重要的分组后也要加排序 order by a.id desc
栏目分类全部>
select a.* from ( SELECT * FROM open_data_co ORDER BY id DESC //里面使用limit固定排序 LIMIT 1000 ) a group by a.id //最重要的分组后也要加排序 order by a.id desc