helixpoint Constraint Violating Yak Guru
250 Posts
James K Flowing Fount of Yak Knowledge
1481 Posts
;WITH c AS ( SELECT ROW_NUMBER() OVER(PARTITION BY col1, col2 ORDER BY col1) AS N FROM ThreeColumnTable ) DELETE FROM c WHERE N > 1;
visakh16 Very Important crosS Applying yaK Herder
India 47023 Posts
DELETE t FROM ( SELECT ROW_NUMBER() OVER (PARTITION BY Email ORDER BY NEWID()) AS Seq FROM Table )t WHERE Seq>1
distinct in select
Posted - 01/15/2013 : 18:57:19
