首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > Mysql >

Mysql oracle剔除重复记录的sql

2013-03-21 
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)

热点排行