What does `CUME_DIST()` window function calculate?

Advanced SQL Developer Medium

Advanced SQL Developer — Medium

What does `CUME_DIST()` window function calculate?

Key points

  • `CUME_DIST()` provides a percentile ranking for each row.
  • The result is a ratio of rows with values less than or equal to the current row.
  • This function is useful for analyzing data distribution in SQL queries.

Ready to go further?

Related questions