[firebird-support] Select Distinct Column Pairs

[Jack Cane]

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

[Robert martin]

Re: [firebird-support] Select Distinct Column Pairs

[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


HTH,
Paul Vinkenoog