| Subject | Re: [firebird-support] Select Distinct Column Pairs |
|---|---|
| Author | Paul Vinkenoog |
| Post date | 2014-03-31T01:52:40Z |
Jack Kane wrote,
HTH,
Paul Vinkenoog
> 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.select distinct <col1>, <col2> from <table>
>
> If that is possible, would one of you please give me an example.
HTH,
Paul Vinkenoog