首页 > 技术文章 > MSSQL删除重复记录
zuqing 2016-02-03 16:33 原文
SQL(根据自己需要改列名、表名):
delete from tableA where id not in (select min(id) from tableA group by name,age)