PERCENT_RANK()

PERCENT_RANK() is a SQL function in the Window Functions category. Calculates the relative rank of a row as a value between 0 and 1. The syntax is PERCENT_RANK() OVER (ORDER BY column). It accepts ORDER BY column. It returns percent rank (0 to 1). A typical example: SELECT name, salary, PERCENT_RANK() OVER (ORDER BY salary DESC) AS percentile FROM employees; -- Highest paid = 0, lowest paid = 1 -- Shows where each employee ranks in the distribution A close relative is ROW_NUMBER(), which assigns a unique sequential integer to each row within its partition (1, 2, 3...). A close relative is RANK(), which similar to ROW_NUMBER but gives the same rank to equal values. Leaves gaps in ranking. A close relative is DENSE_RANK(), which like RANK but without gaps. Equal values get the same rank, and the next number follows sequentially. More about this category: Window/analytical functions — ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, NTILE.