Collections:
CUME_DIST() - Cumulative Distribution of Sorted Values
How to calculate the cumulative distribution of the sorting field expression in the current result set window using the CUME_DIST() function?
✍: FYIcenter.com
CUME_DIST() is a MySQL built-in window function that calculates the cumulative distribution of the sorting field expression in the current result set window. For example:
SELECT help_topic_id, help_category_id, CUME_DIST() OVER w FROM mysql.help_topic WINDOW w AS (ORDER BY help_category_id); -- +---------------+------------------+----------------------+ -- | help_topic_id | help_category_id | CUME_DIST() OVER w | -- +---------------+------------------+----------------------+ -- | 0 | 1 | 0.002932551319648094 | -- | 1 | 1 | 0.002932551319648094 | -- | 2 | 2 | 0.054252199413489736 | -- | 6 | 2 | 0.054252199413489736 | -- | 7 | 2 | 0.054252199413489736 | -- | 8 | 2 | 0.054252199413489736 | -- | 9 | 2 | 0.054252199413489736 | -- ... -- +---------------+------------------+----------------------+
Reference information of the CUME_DIST() function:
CUME_DIST(): val Returns the cumulative distribution of the sorting field expression in the current result set window. Arguments, return value and availability: val: Return value. The cumulative distribution of the sorting field. Available since MySQL 8.
Related MySQL functions:
⇒ DENSE_RANK() - Density Rank of Sorted Values
⇐ MySQL Functions on Result Set Windows
2024-05-15, 226🔥, 0💬
Popular Posts:
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......