摘要： a.如果有ID字段，就是具有唯一性的字段delect table where id not in (select max(id) from table group by col1,col2,col3...)group by 子句后跟的字段就是你用到判斷重复的字段b.,如果是判斷所有字段select * into #aa from table group by id1,id2,....delete ... 阅读全文