What does the CUME_DIST() window function return?

Question

SQL Data Analyst — Medium

What does the CUME_DIST() window function return?

Accepted Answer

The CUME_DIST() window function returns the proportion of rows with an ORDER BY value less than or equal to the current row's value, ranging from 0 to 1. This function helps in calculating the cumulative distribution of a value within a dataset.