摘要：建一个实例表CREATE TABLE [dbo].[User]( [Id] [int] IDENTITY(1,1) NOT NULL, [Name] [nchar](10) COLLATE Chinese_PRC_CI_AS NULL, [age] [int] NULL) ON [PRIMARY]一个sql语句删除重复记录DELETE FROM [USER] WHERE id not IN ( SELECT MIN(ID) AS Id FROM [User] u GROUP BY u.[Name],u.age )DELETE from [User] u where exists(select 阅读全文