SQLServer中删除重复记录的SQL语句

DELETE FROM [dbo].[myTable] WHERE 主键 NOT IN
(SELECT MAX(主键) FROM [dbo].[myTable] GROUP BY 列1, 列2, 列3)从 SQL Server 2005 以后，用 CTE：

WITH tmpOrderdTable
AS
(
SELECT
GroupID = ROW_NUMBER() OVER (PARTITION BY 列1, 列2, 列3 ORDER BY 主键)
FROM
[dbo].[myTable]
)

DELETE FROM tmpOrderdTable WHERE GroupID > 1

declare @max integer,@id integer
declare cur_rows cursor local for select 主字段,count(*) from 表名 主字段 having count(*) > 1
open cur_rows
fetch cur_rows into @id,@max
while @@fetch_status=0
begin
select @max = @max -1
set rowcount @max
delete from 表名 where 主字段 = @id
fetch cur_rows into @id,@max
end
close cur_rows
set rowcount 0

delete [user] from [user] t
inner join(select name,max(id) as id from [user] group by name) a
on t.name = a.name and t.id <> a.id