The rank() window function returns the number of rows that are sorted before the current row +1. Note that rows that have the same values in the order by keys—peers to the current row—are not considered.
SELECT RANK() OVER (ORDER BY …)
FROM …Related
Similar functions:
row_number(),dense_rank(),percent_rank(),cume_dist().
Normative References
The rank() window function is defined in ISO/IEC 9075:2016-2 as part of optional feature T611.
