This question already has an answer here:
- SELECT DISTINCT on multiple columns 5 answers
For starters: yes, I've seen there are lots of questions on combining two/multiple columns - but so far I neither found the answer to my question nor something to get me started trying further (which I did).
I have: a table consisting of two
I want: a single column holding the distinct values of both fields.
| a | b | |---|---| | 1 | 2 | | 1 | 3 | | 1 | 7 | | 2 | 3 | | 3 | 5 | | 5 | 7 |
My desired result would in that case be:
| 1 | | 2 | | 3 | | 5 | | 7 |
Can this be done with a single query? What would that look like?
// EDIT: some side info (which I think is irrelevant, however, I don't want to hide it):
b is always greater than a.