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