SQL PERCENTILE_DISC

The SQL PERCENTILE_DISC will calculate a percentile of the sorted values within an entire row set, or within the partitions in a table. The basic syntax of the PERCENTILE_DISC in SQL Server analytic function is as shown below: SELECT PERCENTILE_DISC(Numerical_Literal) WITHIN GROUP ( ORDER BY_Clause) OVER ( PARTITION_BY_Clause ) FROM [Source] Numerical_Literal: Specify the Percentile to compute. … Read more