Oracle SQL / PLSQL PERCENT_RANK function is used to calculate the rank of a hypothetical row. As an aggregate function a rank is calculated as r minus 1 divided by the number of rows in the aggregate group. As an analytical function rank is calculated as r minus 1 divided by the number of rows […]