SELECT Name, COUNT(*) AS Repeats
FROM city
GROUP BY Name
HAVING COUNT(*) > 1
ORDER BY Repeats DESC, Name
| Name | Repeats |
| San José | 4 |
| Cambridge | 3 |
| Córdoba | 3 |
| Hamilton | 3 |
| La Paz | 3 |
| León | 3 |
| Richmond | 3 |
| San Fernando | 3 |
| San Miguel | 3 |
| Springfield | 3 |
| ... |
| GROUP BY 把 Name 相同的行归为一组，HAVING COUNT(*) > 1 只保留多于一行的组。结果就是出现不止一次的值，以及每个值的重复次数。包含这些值的完整行，由本节的其他示例返回。 |