你的字段都没搞出来,怎么啊,我假如你只有三个字段,一个ID,一个column1,column2吧:Delete From table where ID not in (Select min(iD) From Table group by column1,column2) --有多少个字段,group by 后面加多少个,ID除外
你的字段都没搞出来,怎么啊,我假如你只有三个字段,一个ID,一个column1,column2吧:Delete From table where ID not in (Select min(iD) From Table group by column1,column2) --有多少个字段,group by 后面加多少个,ID除外 追问字段神马的不