basically i want to remove dups in a table.
i have a table called productincludes
it has a few fields listed here:
i ran a update for a business request that made many dup rows and want to clean this up. when i run this select to check on how many dups to verify cleanup:
select count(*) ctz,ParentProductID,
ChildProductID, IncludeStatus from products_productincludes
where IncludeStatus =0
group by ParentProductID,
order by ctz desc
notice i am grouping by only 3 of the rows not all the rows in the table !!!
i want only the rows that dup cause of these 3 rows to go away. the rest that are outside the groub by clause should stay. that is to say there can be more dups in the table as long as i dont have any dups on these 3 fields. thats what i want to achieve here.
thank you for the help
October 17, 2008 3:59 PM
October 20, 2008 4:14 PM