v.23.5Improvement

Allow ntile window function without explicit frame definition

Official CH changelog text
Allow using ntile window function without explicit window frame definition: ntile(3) OVER (ORDER BY a), close #46763. #49093 (vdimir).
Allow the ntile window function to be used without specifying an explicit window frame, enabling syntax like ntile(3) OVER (ORDER BY a).

Why it matters

Previously, using the ntile window function required defining a window frame explicitly. This feature simplifies queries by allowing ntile to operate directly over an ordered set of rows without the need for a frame definition, making query writing more convenient and intuitive.

How to use it

Use the ntile function in window functions without an explicit window frame, for example:

SELECT ntile(3) OVER (ORDER BY a) FROM table

Related resources

PreviousNext