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 19:07:24 +0100 |
| commit | 4a89aa25c91e520c247aee428782274dcf10ffd0 (patch) | |
| tree | 26d2ba9a26735f1e4c21841acc770075b6c7d097 /docs/ref | |
| parent | a0623b117c2fc74a4eea46f8adb914182a5670b5 (diff) | |
[4.2.x] 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.
Backport of 7bb741d787ba360a9f0d490db92e22e0d28204ed from main
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 71c98fd73e..f33e4f5370 100644 --- a/docs/ref/models/database-functions.txt +++ b/docs/ref/models/database-functions.txt @@ -1758,16 +1758,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 @@ -1775,7 +1775,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`` -------- |