Sunday 26 February 2012

Data duplicates delete query in sql server


sql server database Table duplicate data, so we want to remove duplicate data by query,,,,,,,
use thid query  ....write your dupliucate column name in
in this table we have id and ProductMain  duplicate data insert so delete data by using this


With duplicates

As
(Select *, ROW_NUMBER() Over (PARTITION by id,ProductMain Order by id) as Duplicate From Admin_ProductDescription)

delete From duplicates

Where Duplicate > 1 ;

No comments:

Post a Comment