[firebird-support] Select Distinct Column Pairs
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. Best, jwc
Re: [firebird-support] Select Distinct Column Pairs
Re: [firebird-support] Select Distinct Column Pairs
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 HTH, Paul Vinkenoog