去除edu_records表中重复member_id的记录,只保存最新的教育记录。
(select rr.id edu_id,member_id from
edu_records rr where not exists(select 1 from edu_records where rr.member_id = member_id and rr.id<id)) r
去除edu_records表中重复member_id的记录,只保存最新的教育记录。
(select rr.id edu_id,member_id from
edu_records rr where not exists(select 1 from edu_records where rr.member_id = member_id and rr.id<id)