我一直在疯狂地尝试从sql server数据库中删除重复的值。一次查询工作，然后它就不工作了。假设这个查询删除了DUP，但在查询时却没有。以下是表格结构：

CREATE TABLE [dbo].[Location](
    [ID] [int] NOT NULL,
    [FullName] [nvarchar](255) NULL,
    [BarCode] [nvarchar](255) NULL,
    [Alias] [nvarchar](255) NULL,
    [StreetAddress] [nvarchar](255) NULL,
    [City] [nvarchar](255) NULL,
    [State] [nvarchar](255) NULL,
    [ZipCode] [nvarchar](255) NULL,
    [ArchiveDate] [datetime] NULL DEFAULT (getdate()),
PRIMARY KEY CLUSTERED 
(
    [ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

这是我用来删除重复项的查询：

WITH CTE([FullName], 
        [BarCode],
        [Alias],
        [StreetAddress],
        [City],
        [State],
        [ZipCode],
      --    [ArchiveDate],   
    DuplicateCount)
AS (SELECT [FullName], 
           [BarCode],
           [Alias],
           [StreetAddress],
           [City],
           [State],
           [ZipCode],
          -- [ArchiveDate],
           ROW_NUMBER() OVER(PARTITION BY [FullName], 
                            [BarCode],
                        [Alias],`enter code here`
                        [StreetAddress],
                        [City],
                        [State],
                        [ZipCode]
                        --[ArchiveDate]                           
           ORDER BY ID) AS DuplicateCount
    FROM [TelusArchive].[dbo].[Location])
DELETE FROM CTE
WHERE DuplicateCount > 1;

它不是删除重复项。我做错什么了。。
谢谢你的帮助。。。