Mysql oracle剔除重复记录的sql

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)