New SQL features in ClickHouse 25.10

Mark Needham

A quick, example-driven look at three SQL additions in ClickHouse 25.10: a NULL-aware comparator, end-of-result pagination that keeps ordering intact, and a shorter way to limit rows per group.

• IS NOT DISTINCT FROM for clear TRUE/FALSE results when NULLs appear
• Negative LIMIT and OFFSET to pull the last N rows and browse backwards, still in ascending order (property sales example) SQL-25.10-Take1
• LIMIT … BY ALL to de-duplicate repeated combos with a single keyword

Release blog - https://clickhouse.com/blog/clickhouse-release-25-10