PERCENT_RANK

External Article

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

  • Article

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

Blogs

Daily Coping 19 Oct 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Commenting a branching IF-THEN-ELSE.

By

I’m a big fan of comments (MSSQL, Powershell), so along those lines here’s an...

External Temp Tables Preventing Plan Reuse in Stored Procedures

By

Here’s an interesting issue that recently came up. We were seeing very high compilations...

Read the latest Blogs

Forums

How to get the 16 tables that are not in TEST but are there in PROD?

By coolchaitu

I have a database D1 in Prod and TEST. In Prod D1 has 266...

Going Cloud Native

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Going Cloud Native

Change Tracking Default Retention

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Change Tracking Default Retention

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers