v.1.1.54362New Feature

Support for Arbitrary Expressions in LIMIT BY Clauses

Official CH changelog text
Arbitrary expressions are supported in LIMIT BY clauses. Previously, it was only possible to use columns resulting from SELECT.
Arbitrary expressions can now be used in LIMIT BY clauses, whereas previously only columns resulting from SELECT were supported.

Why it matters

This feature allows more flexible and powerful usage of the LIMIT BY clause by enabling arbitrary expressions, which were previously restricted to simple column references. It helps users perform more complex row limiting based on calculated or transformed values within queries.

How to use it

Use arbitrary expressions directly within the LIMIT BY clause in your SQL queries. For example, instead of limiting by a column, you can use expressions such as LIMIT BY a + b, n where a + b is an arbitrary expression.
PreviousNext