Subject Re: [firebird-support] Select Distinct Column Pairs
Author Paul Vinkenoog
Jack Kane wrote,

> One of my tables has about 140 distinct values in one column and 70 in another column. would like to design a query that selects distinct pairs of values, so that each pair is unique.
> If that is possible, would one of you please give me an example.

select distinct <col1>, <col2> from <table>

Paul Vinkenoog