Filter by COUNT(*)?

by

You want to use HAVING to filter on the aggregate function.

SELECT name, COUNT(*)
    FROM mytable
    GROUP BY name
    HAVING COUNT(*) > 1

More Related Contents:

  1. get first occurrence of last changed value of a column [closed]
  2. MySQL – Rows to Columns
  3. ROW_NUMBER() in MySQL
  4. multiple query same table but in different columns mysql
  5. How can I make SQL case sensitive string comparison on MySQL?
  6. 1052: Column ‘id’ in field list is ambiguous
  7. How can I temporarily disable a foreign key constraint in MySQL?
  8. How to do a batch insert in MySQL
  9. Count the occurrences of DISTINCT values
  10. Ordering by the order of values in a SQL IN() clause
  11. Creating a “Numbers Table” in MySQL
  12. SQL Selecting from two Tables with inner join and limit [duplicate]
  13. MySQL Group by SUM
  14. Cumulative sum over a set of rows in mysql
  15. Set NOW() as Default Value for datetime datatype?
  16. SQL: selecting rows where column value changed from previous row
  17. Why do results from a SQL query not come back in the order I expect?
  18. How to generate data in MySQL?
  19. MySQL combine two columns and add into a new column
  20. SQL query of multiple values in one cell
  21. How to skip certain database tables with mysqldump?
  22. MySQL error 1241: Operand should contain 1 column(s)
  23. How to set a MySQL row to READ-ONLY?
  24. Mysql: Order by like?
  25. Getting first day of the week in MySql using Week No
  26. How to format number with “.” as thousands separator and “,” as decimal separator?
  27. Using DISTINCT and COUNT together in a MySQL Query
  28. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  29. Convert SQL Server query to MySQL [duplicate]
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment