Subject Re: [firebird-support] Select Distinct Column Pairs
Author Robert martin
On 31/03/2014 2:34 p.m., Jack Cane 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.

Hi Jack

This is one way of doing it :)

SELECT DistinctColA,  DistinctColB
FROM myTable
GROUP BY DistinctColA,  DistinctColB