Mysql oracle删除重复记录的sqlMYSQLdelete from gqh_sch_info where sch_namein (selectsch_namefrom gqh
Mysql oracle删除重复记录的sql
MYSQL
delete from gqh_sch_info where sch_name in (select sch_name from gqh_sch_info group by sch_name having count(sch_name) > 1)and rowid not in (select min(rowid) from gqh_sch_info group by sch_name having count(sch_name)>1)