Advanced SQL Developer — Hard
Key points
- CUME_DIST() calculates the cumulative distribution of values in a window function.
- It provides a normalized value between 0 and 1 for each row.
- This function is useful for analyzing the distribution of data within a partition.
Ready to go further?
Related questions
