B
Bob
select orderno, ssn from test
group by ssn,orderno order by orderno
Not sure if this will give you the flexibility you need,
but may get you in the right direction.
just seeked all the duplicate records out of my system,
and I found that it was very efficient to have the
records listed in order of file #.
followed by all records that have a matching SSN.
(Usually 1, possibly 2 or 3) Then, I would like the next
lowest record to be listed after, followed by the records
which match its SSN.
group by ssn,orderno order by orderno
Not sure if this will give you the flexibility you need,
but may get you in the right direction.
my filing system using the find duplicate query. I have
just seeked all the duplicate records out of my system,
and I found that it was very efficient to have the
records listed in order of file #.
order: The lowest numbered record will be first,
followed by all records that have a matching SSN.
(Usually 1, possibly 2 or 3) Then, I would like the next
lowest record to be listed after, followed by the records
which match its SSN.