select r.* from recruit r where id = (select max(id) from recruit where (school_id = r.school_id));
sql查询相同条件记录中最大的一条的值
最新推荐文章于 2024-08-12 03:14:44 发布
select r.* from recruit r where id = (select max(id) from recruit where (school_id = r.school_id));