Skip to content

Instantly share code, notes, and snippets.

@sklyar
Created February 10, 2020 12:38
Show Gist options
  • Save sklyar/957f8a5a841397fc6dc991b71294fea1 to your computer and use it in GitHub Desktop.
Save sklyar/957f8a5a841397fc6dc991b71294fea1 to your computer and use it in GitHub Desktop.
SELECT max(count)
FROM
(
SELECT
count() AS count,
toStartOfDay(EventDate) AS date
FROM table
GROUP BY date
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment