v.25.11New Feature

Fractional LIMIT and OFFSET

Official CH changelog text
Add support for fractional LIMIT and OFFSET for selecting a fraction of a table. Closes #81892. #88755 (Ahmed Gouda).
Add support for fractional LIMIT and OFFSET clauses to select a fraction of rows from a table.

Why it matters

This feature allows users to specify LIMIT and OFFSET values as fractions (percentages) of the total number of rows in a table, simplifying operations where a relative portion of data is needed rather than an absolute number of rows.

How to use it

Users can specify fractional values in LIMIT and OFFSET clauses by providing decimal fractions instead of integers. For example: SELECT * FROM table LIMIT 0.1 OFFSET 0.2 will return 10% of the rows after skipping 20% of them.

Related resources

PreviousNext