;with DelDup as (select row_number() over (partition by
ID order by ID) as RowNo from duplicateTest )
Delete from DelDup where RowNo> 1
Type: Posts; User: RajneshBansal; Keyword(s):
;with DelDup as (select row_number() over (partition by
ID order by ID) as RowNo from duplicateTest )
Delete from DelDup where RowNo> 1