Mysql Unique / distinct rows based on two or more columns

Question

I have a table where I have the following columns - lets call location table city, state, zipcode, lat, lng

The problem is that every city and state can multiple zip codes e.g.

belleuve, wa, 98004 bellevue, wa, 98006

Similarly a city name can be also present in some other state e.g.

bellevue, TN, 05156

How do I select a distinct city e.g. Bellevue for each state. Basically the result should show both Bellevue, WA and Bellevue, TN but for WA only one occurance of Bellevue.

Tim Biegeleisen · Accepted Answer · 2018-10-19 03:55:03Z

1

Grouping by the city and state should work here:

SELECT City, State
FROM yourTable
GROUP BY City, State;

We also could use DISTINCT:

SELECT DISTINCT City, State
FROM yourTable;

answered Oct 19, 2018 at 3:55

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

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

Collectives™ on Stack Overflow

Mysql Unique / distinct rows based on two or more columns

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related