Skip to content

Instantly share code, notes, and snippets.

@goyuninfo

goyuninfo/mysql-group-by-hour-example.sql

Created December 8, 2020 16:16
Show Gist options
  • Save goyuninfo/cecce15fb137513896d479a26e168ff0 to your computer and use it in GitHub Desktop.
Save goyuninfo/cecce15fb137513896d479a26e168ff0 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql-group-by-hour-example.sql
SELECT t.date, count(*)
FROM table1 t
GROUP BY hour( t.date ) , day( t.date )
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment