Subject data retrieval
Author p_b_turner

have a table with the following conceptual data...
rec# col1 col2 ... coln
1 1 d data
2 1 m data
3 1 d data
4 2 d data
5 2 m data
6 3 d data
7 3 m data
8 3 d data

trying to come up with a single query that would return unique records
where the combination of col1 and col2 are unique. in the example,
would want rec #1, #2, #3, #4, #6, and #7.

have come up with a couple of multiple query ideas, but was wondering
how to do this in a single query (if possible).


Pete Turner
Sun Nuclear Corp.