PostgreSQL: Calculate Percent Rank and Cumulative Percent Rank

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

In this post, I am sharing the use of two functions of PostgreSQL which are PERCENT_RANK() and CUME_DIST().
Using these functions, we can calculate the Percent Rank and Cumulative Percent Rank of number column.

We know about the normal RANK(), which generates the rank of the number. But sometimes, it requires checking the percentage instead of rank.

Please check the below demonstration:

Create a sample table with data:

Calculate the Percent rank and Cumulative Percent rank:

The Result: