M
mabl
I'd really appreciate any ideas or suggestions on the
following question. I have a table where a "customer" can
occur several times. I only want to display those records
that are unique but the problem I have is that two, or
more, records can be identical where the only difference
is that one contain more information than the other(s)
An example to illustrate:
Column Cust B C D
1 1 1
1 1 1
1 1 1 1
2 1 1
3 1 1
3 1
All three records are unique but the one of interest is
that which contain the most information (the third record
in the above example contain information to render the
other two irrelevant)
Using DISTINCT won't work as the records are all unique
and so my question is if someone can suggest how a query
that only displays those records that contain the
information of all the others could be written.
Referring to the example again, the third fourth and fifth
row would be returned.
Any help or suggestions appreciated
Cheers
following question. I have a table where a "customer" can
occur several times. I only want to display those records
that are unique but the problem I have is that two, or
more, records can be identical where the only difference
is that one contain more information than the other(s)
An example to illustrate:
Column Cust B C D
1 1 1
1 1 1
1 1 1 1
2 1 1
3 1 1
3 1
All three records are unique but the one of interest is
that which contain the most information (the third record
in the above example contain information to render the
other two irrelevant)
Using DISTINCT won't work as the records are all unique
and so my question is if someone can suggest how a query
that only displays those records that contain the
information of all the others could be written.
Referring to the example again, the third fourth and fifth
row would be returned.
Any help or suggestions appreciated
Cheers