Understanding Statistical Functions
Kathi Kellenberger, Clayton Groom, Ed Pollack · Apress eBooks · 2019
In 2012, Microsoft added four more window functions to SQL Server. These are statistical functions PERCENT_RANK , CUME_DIST , PERCENTILE_CONT , and PERCENTILE_DISC . These functions make analyzing data from many sources, such as science, academics, or sports, easy.