常用SQL语句(整)

1。删除重复记录

delete from table1 where [id] not in(select min([id]) from table1 group by field1,field2)