I'm trying to use SQL to select uniquely duplicative service dates, all records of which are contained within a single table. Here's a sample starting table:
GroupID | ServiceID | ServiceDate |
---|---|---|
A | X | 1/1/2010 |
A | Y | 1/1/2010 |
A | Z | 10/1/2010 |
I've figured out how to find 2 different records that have the same date and get them in one row, but I end up with a somewhat duplicated table, as it's comparing each record to all others:
GroupID | ServiceID1 | ServiceDate1 | ServiceID2 | ServiceDate2 |
---|---|---|---|---|
A | X | 1/1/2010 | Y | 1/1/2010 |
A | Y | 1/1/2010 | X | 1/1/2010 |
I don't want the last row, as it's essentially a duplicate of the first.
Any ideas for how to get rid of that second row?