I need to delete all rows where you have same Supplier-ID, Customer-ID, Order1_Date, Order2_Date, Name BUT different Type.
Only when we have 2 records with Type-1 and Type-2 for the Type column, we need to delete one of these records.
I need help writing this query.
Thanks in advance.
Supplier-ID Customer-ID Order1_Date Order2_Date Order3_Date Order4_Date Name Type 00001 001 3/30/2011 4/6/2011 3/30/2011 4/6/2011 John Type-1 00001 001 3/30/2011 4/6/2011 4/3/2011 4/6/2011
John Type-2