PERCENT_RANK

Percentiles give meaning to measurements by telling you the percentage of the population being measured who get higher or lower values. They are now easier to calculate in SQL, and are useful for reporting; but are the new analytic functions faster and more efficient than the older methods? Dwain Camps demonstrates, and investigates their relative performance.

2015-05-27

7,757 reads

Question of the Day

I have some data in a table that looks like this:

BeerID BeerName brewer beerdescription 1 Becks Interbrew Beck's is a German-style pilsner beer 2 Fat Tire New Belgium Toasty malt, gentle sweetness, flash of fresh hop bitterness. 3 Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste 4 Alaskan Amber Alaskan Brewing Alaskan Brewing Amber Ale is an "alt" style beer 8 Kirin Kirin Brewing Kirin Ichiban is a Lager-type beer

select t1.[key] from openjson((select t.* FROM Beer AS t for json path)) t1

See possible answers

PERCENT_RANK

What’s the Difference Between PERCENT_RANK and CUME_DIST?

The percent ranks

Nasty Fast PERCENT_RANK

Using the T-SQL PERCENTILE Analytic Functions in SQL Server 2000, 2005 and 2008

Blogs

Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption

Why your data still can’t answer a simple question

T-SQL Tuesday #197 Invitation – An impactful session or two from a conference

Forums

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

Daily aggregation of Azure Blob Storage by tier (created/tier-change/deleted)

SQL 2017 to SQL 2025. Good to Go ?

Question of the Day

Using OPENJSON