3 ms·
In ClickHouse we have argMin/argMax aggregate functions. And also LIMIT BY. It looks like this: ... ORDER BY date DESC LIMIT 1 BY user_id
by zX41ZdbW 5y ago
In ClickHouse we have argMin/argMax aggregate functions.
And also LIMIT BY. It looks like this:
... ORDER BY date DESC LIMIT 1 BY user_id