一句sql语句删除重复记录
时间:2011-02-18 来源:adu123
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 )
相关阅读 更多 +