|Re: [firebird-support] Select Distinct Column Pairs
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.
This is one way of doing it :)
SELECT DistinctColA, DistinctColB
GROUP BY DistinctColA, DistinctColB