CHAPTER 8
Understanding Statistical Functions
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.
In this chapter you will learn how to use these statistical functions.
Using PERCENT_RANK and CUME_DIST
Remember those standardized tests you took in school? You were probably given a raw score and a percent for each area tested, such as mathematics or language skills. Percent rank is a way to calculate how each individual in a group compares ...
Get Expert T-SQL Window Functions in SQL Server now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
