Java MySQL DISTINCT for Multiple Columns

Question

I have two columns in my DB with team names in each column. But, sometimes a team could be in one column, and sometimes it can be in the other column. I want to create a list of distinct, unique, names from both columns combined.

Maybe for further explanation, what I'm trying to say is combine the two columns and then run a distinct query on the combined data to get only unique names out. Thanks!

juergen d · Accepted Answer · 2015-07-18 02:18:11Z

2

Use union to get a distinct list

select team1 as team from your_table
union 
select team2 from your_table

answered Jul 18, 2015 at 2:18

juergen d

205k40 gold badges305 silver badges377 bronze badges

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

2 Comments

Scooter Over a year ago

So will the result set have only unique team names? Or does this just return a list of the two combined teams and then I have to run a DISTINCT query?

juergen d Over a year ago

union all would return the total list, but just union reduces it to the distinct values

Collectives™ on Stack Overflow

Java MySQL DISTINCT for Multiple Columns

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related