• Here is a sample result set:

    InvoiceID DueDate GroupID SubscriberID

    101 1/31/12 4 22222

    102 1/31/12 4 22222

    103 1/15/12 5 33333

    So you see the first 2 records have the same due date, same group id , and same subscriber Id and the 3rd record is completely different...

    I want my final result set to be:

    InvoiceID DueDate GroupID SubscriberID

    102 1/31/12 4 22222

    103 1/15/12 5 33333