delete from student_manage_comquality where id in (
select a.id from
(select min(id) id,
student_id,bylaw_id,classes_id,company_id,branch_id,lea_year_term_id
from student_manage_comquality
where bylaw_id=88
GROUP BY student_id,bylaw_id,classes_id,company_id,branch_id,lea_year_term_id
HAVING count(1)>1) a
)
java mysql删除重复数据
最新推荐文章于 2023-03-14 16:20:26 发布