|Subject||RE: [firebird-support] data retrieval|
> hi,but #5 is unique too no?
> 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.
try a view on ditinct col1, col2
then join the other data to the view