MySQL Count with a condition

Question

Let's say I have a table which contains cities and names. But in a city, the names are duplicate. How can I count the duplicate names which belong to every distinct city?

SonalPM · Accepted Answer · 2014-11-17 11:20:41Z

1

select count(name) from Table group by CITY having count(*) > 1

answered Nov 17, 2014 at 11:20

SonalPM

1,3338 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

MySQL Count with a condition

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