diff options
| author | dennisvang <29799340+dennisvang@users.noreply.github.com> | 2023-02-10 12:11:31 +0100 |
|---|---|---|
| committer | Mariusz Felisiak <felisiak.mariusz@gmail.com> | 2023-02-10 14:07:48 +0100 |
| commit | 7bb741d787ba360a9f0d490db92e22e0d28204ed (patch) | |
| tree | ff3e0840b42c3db43a3099ee88e353e9edb6b7f1 /docs/ref | |
| parent | a18d20ca97e6799152c1e0b6f007fde943053dcb (diff) | |
Fixed #34325 -- Corrected wording in PercentRank() docs.
This is consistent with the terminology used for the percent_rank()
function in SQLite docs and PostgreSQL docs.
Diffstat (limited to 'docs/ref')
| -rw-r--r-- | docs/ref/models/database-functions.txt | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/docs/ref/models/database-functions.txt b/docs/ref/models/database-functions.txt index 78239be2f5..0c91bebfa4 100644 --- a/docs/ref/models/database-functions.txt +++ b/docs/ref/models/database-functions.txt @@ -1738,16 +1738,16 @@ more frequently. .. class:: PercentRank(*expressions, **extra) -Computes the percentile rank of the rows in the frame clause. This -computation is equivalent to evaluating:: +Computes the relative rank of the rows in the frame clause. This computation is +equivalent to evaluating:: (rank - 1) / (total rows - 1) -The following table explains the calculation for the percentile rank of a row: +The following table explains the calculation for the relative rank of a row: -===== ===== ==== ============ ============ -Row # Value Rank Calculation Percent Rank -===== ===== ==== ============ ============ +===== ===== ==== ============ ============= +Row # Value Rank Calculation Relative Rank +===== ===== ==== ============ ============= 1 15 1 (1-1)/(7-1) 0.0000 2 20 2 (2-1)/(7-1) 0.1666 3 20 2 (2-1)/(7-1) 0.1666 @@ -1755,7 +1755,7 @@ Row # Value Rank Calculation Percent Rank 5 30 5 (5-1)/(7-1) 0.6666 6 30 5 (5-1)/(7-1) 0.6666 7 40 7 (7-1)/(7-1) 1.0000 -===== ===== ==== ============ ============ +===== ===== ==== ============ ============= ``Rank`` -------- |