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
2023-12-19, 215🔥, 0💬
Popular Posts:
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...