Apache Derby BigQuery Db2 (LUW) H2 MariaDB MySQL Oracle DB PostgreSQL SQL Server SQLite 2005 2007 2009 2011 2013 2015 2017 2019 2021 ✓ 3.25.0+ ⊘ 3.5.7 - 3.23.1 ✓ 2012+ ⊘ 2008R2 ✓ 8.4+ ⊘ 8.3 ✓ 11gR1+ ✓ 8.0.11+ ⊘ 5.0 - 5.7 ✓ 10.2+ ⊘ 5.1 - 10.1 ✓ 1.4.198+ ⊘ 1.4.191 - 1.4.197 ✓ 11.1+ ⊘ 9.7 - 10.5 ✓ 2.0+ ⊘ 10.15.1.3 - 10.16.1.1 The cume_dist() window function returns a relative measure (0-1) of where the current row is in the result according to the order by clause.
SELECT cume_dist() OVER (ORDER BY …)
FROM …Normative References The cume_dist() window function is defined in ISO/IEC 9075:2016-2 as part of optional feature T612, “Advanced OLAP operations” .
About the Author Markus Winand is the SQL Renaissance Ambassador. He is on a mission to introduce developers to the evolution of SQL in the 21st century . Markus can be hired as trainer, speaker and consultant via winand.at .
