joi, 16 aprilie 2015

How to count duplicate rows!

Hello, bellow is MySQL query to count duplicate rows by value.

SELECT DISTINCT(user_city) as city, count(user_city) AS count 
FROM users
GROUP BY user_city
HAVING count > 5

Niciun comentariu:

Trimiteți un comentariu