Menu
I want to do something like this:
SELECT * FROM db.table WHERE COUNT(someField) > 1 How can I achieve this in MySql?
376
You can GROUP BY multiple columns, to get the count of each combination. Show activity on this post. Show activity on this post.
SQL SELECT COUNT() can be clubbed with SQL WHERE clause.
If you want to insert more rows than that, you should consider using multiple INSERT statements, BULK INSERT or a derived table. Note that this INSERT multiple rows syntax is only supported in SQL Server 2008 or later. To insert multiple rows returned from a SELECT statement, you use the INSERT INTO SELECT statement.
Use the HAVING, not WHERE clause, for aggregate result comparison.
Taking the query at face value:
SELECT * FROM db.table HAVING COUNT(someField) > 1 Ideally, there should be a GROUP BY defined for proper valuation in the HAVING clause, but MySQL does allow hidden columns from the GROUP BY...
Is this in preparation for a unique constraint on someField? Looks like it should be...
122
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
