[Solved] How to get the count of day with most rows with MySQL

by


Group the rows by date, use COUNT(*) to get the count of rows in each group, and then use ORDER BY and LIMIT to get the highest count.

SELECT DATE(timestampColumn) AS date, COUNT(*) AS count
FROM yourTable
GROUP BY date
ORDER BY count DESC
LIMIT 1

9

solved How to get the count of day with most rows with MySQL