New Aggregate Functions Quantilesexactinclusive and Quantilesexactexclusive Which Were Proposed in #5885

Why it matters

These functions address the need for precise quantile calculation methods in ClickHouse, providing users with exact quantile results rather than approximations. This improves accuracy in statistical analysis and data summarization tasks.

How to use it

Use the new aggregate functions in your SQL queries as follows:

SELECT quantilesExactInclusive(0.25, 0.5, 0.75)(column_name) FROM table_name;
SELECT quantilesExactExclusive(0.25, 0.5, 0.75)(column_name) FROM table_name;

Replace column_name and table_name with your actual column and table names. Specify the desired quantile probabilities as arguments.