rank

Computes the rank of the hypothetical row, with gaps; that is, the row number of the first row in its peer group.

English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

group: aggregate
group label: 聚合函数
lang: en
layout: table-new
pages: functions-aggregate.html, functions-window.html
prose only: false

Definition PG 18

Computes the rank of the hypothetical row, with gaps; that is, the row number of the first row in its peer group.

Signatures and overloads

rank ( args ) WITHIN GROUP ( ORDER BY sorted_args ) → bigint → bigint

Computes the rank of the hypothetical row, with gaps; that is, the row number of the first row in its peer group.

rank () → bigint → bigint

Returns the rank of the current row, with gaps; that is, the row_number of the first row in its peer group.

Compare versions

Complete source facts

documentation revision

{"inputs":[{"file":"functions-aggregate.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"31d3dcd36ef353484b4b3535f9f0d1cc239c3910146257fe5178f99b90b501e2","version":"18.7"},{"file":"functions-window.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"439ef40b6ad39f35f5b4543f2cf5766744ce6b7a8c5c75c0b4c0a7c27cbb7574","version":"18.7"},{"file":"functions-aggregate.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"0bf7506d27b71666fc74840a21a8f77c8a92735174f1d05033865961722e457c","version":"18.7"},{"file":"functions-window.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"cf993ee76845c3f6c445b1045d674ce10d648125a8444e263a13384ed0e268f0","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:596ec190f76b1f5d31343b96775cd2436973ccfa36415c89d641ce6082a265e5

Text language: en · wiki-repair-20261023:596ec190f76b1f5d31343b96775cd2436973ccfa36415c89d641ce6082a265e5