sql get a unique combination of two columns without duplications (unique values in each column)

Asked Jun 24 '23 at 19:29

Active Jun 24 '23 at 19:32

Viewed 25 times

Sample data:

a            b
-------      ---------
1       /     2     
1       /     3
2       /     1
3       /     1
3       /     2
2       /     1
3       /     2

I have the above sample data. What i want is to select the unique (and distinct) rows of the combination A and B. In the above example the only matching results are

A            B
-------      ---------
1      /      2
2      /      1

db used: access Tanks

edited Jun 24 '23 at 19:32

nbk

45,398
8
30
47

asked Jun 24 '23 at 19:29

user3075359

and why not a 3? – nbk Jun 24 '23 at 19:33
Do you want to count unique B items for each A value? If not, clarify rules for "unique (and distinct) rows of the combination A and B". – June7 Jun 24 '23 at 19:49

sql get a unique combination of two columns without duplications (unique values in each column)

0 Answers0