Mar 10

ACCESS 删除表中重复记录 保留一笔原记录 SQL

MS ACCESS               共有人观看过

找了很久才找到的删除表中 相同记录.而又保留一笔原记录的SQL语句

以下是 PEOPLE 表  有PEOPLEID 和ROWID 字段  

ROWID字段一定要不重覆的值..例如主键还自动编号就最好了..要不然.没效果

delete * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
...

  [«]1[»]