How do I get distinct count values of 2 columns?

Question

Lets say I have 2 columns, a and b.

Column A contains these values:

a
b
c
d

Column B contains these values:

e
d
c
b
a

What can I do to get the absolute distinct values from BOTH columns?

Meaning if i want to have a count on both columns, the result is to be 5. Because a, b, c and d are repeated in column B but not e.

Yosi Dahari · Accepted Answer · 2013-11-15 09:57:10Z

3

SELECT A
FROM YourTable
UNION
SELECT B
FROM YourTable

answered Nov 15, 2013 at 9:57

Yosi Dahari

7,0495 gold badges26 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1