SQL server删除反双数据的处理计划(国外英语资料).doc

SQL server删除重复数据的解决方案 SQL deletes the solution for duplicate data Such as: Id????????????? Name????????? The value 1????????????? A??????? pp 2????????????? A??????? pp 3????????? ????????????????????? Iii. 4??????? ????????????????????? pp 5???? ????????????????????? pp 6????????????? ????????????????????????????????????? pp 7?????? ????????????????????????????????????? pp 8????????? ????????????????????????????????????? Iii. Id is the primary key And you want to get that Id????????????? Name????????? The value 1????????????? A??????? pp 3????????? ????????????????????? Iii. 4??????? ????????????????????? pp 6????????????? ????????????????????????????????????? pp 8????????? ????????????????????????????????????? Iii. Method 1 Delete?? YourTable?? Where?? [id]???? Not?? In?? ( Select?? Max ([id])? The from?? YourTable?? Group?? By?? Name?????? Value) Method 2 Delete?? a. The from?? Table?? A???? Left?? The join ( Select?? Id = min (id)?? The from?? Table?? Group?? By?? The name of the value B?? On?? Anderson, d = b.i d Where?? B.i d?? Is???? null Query and delete SQL statements that repeat records Query and delete SQL statements that repeat records Look for redundant duplicate records in the table, which are determined by the individual field (the peopleId) Select * from people Where peopleId in? To remove redundant duplicate records from the table, the duplicate record is determined by the individual field (the peopleId), leaving only the minimum record for rowid The delete from people Where peopleId in (select??) And rowid not in. Look for redundant duplicate records in the table (multiple fields) Select * from vitae a Where (a.p eopleId, a.s eq) in? (select peopleId, seq from vitae group by peopleId, seq having count (*) 1) Remove redundant duplicate records from the table (multiple fields), leaving only the record for the smallest rowid The delete from vitae a. Where (a.p eopleId, a.s eq) in? (select peopleId, seq from vitae group by peopleId, seq having count