Skip to content

Instantly share code, notes, and snippets.

@sklyar

sklyar/clickhouse-get-max-count-inserts-per-day.sql

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.
Download ZIP
Raw
clickhouse-get-max-count-inserts-per-day.sql
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