MSSQL删除重复记录

  SQL(根据自己需要改列名、表名):

delete from tableA where id not in (select min(id) from tableA group by name,age)

posted @ 2016-02-03 16:33  ZuQing  阅读(366)  评论(0编辑  收藏  举报