Thank you Paul.
Best,
jwc
On Mar 30, 2014, at 9:52 PM, Paul Vinkenoog p...@vinkenoog.nl wrote:
select distinct col1, col2 from table
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
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,
