[firebird-support] Select Distinct Column Pairs

2014-03-30 Thread 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

2014-03-30 Thread Robert martin













Re: [firebird-support] Select Distinct Column Pairs

2014-03-30 Thread 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