Tags for ntile
Missing functions: CUME_DIST & NTILE
In my previous post i covered some ranking functions including SQL:2008 RANK, ROW_NUMBER & DENSE_RANK. But Standard SQL defines three additional functions based on ranking: PERCENT_RANK and CUME_DIST as relative rankings and a percentile calculation named NTILE.
quantile cume_dist ntile