I have the following records with 4 fields:
test1, 1, 1
test1, 3, 4
test3, 1, 1
test4, 1, 2
test4, 1, 3
I would like to return:
test1, 1, 1
test4, 1, 2
test4, 1, 3
test1, 3, 4
That is, I would like to get the non-distinct records ONLY non-distinct on only the first field. Note that on the first 2 records, the third field is different.
Thanks!
Adam
test1, 1, 1
test1, 3, 4
test3, 1, 1
test4, 1, 2
test4, 1, 3
I would like to return:
test1, 1, 1
test4, 1, 2
test4, 1, 3
test1, 3, 4
That is, I would like to get the non-distinct records ONLY non-distinct on only the first field. Note that on the first 2 records, the third field is different.
Thanks!
Adam