if there are n records in a partition and the rank of the record is r, then which is equivalent to (r-1)/(n-1) code example

Example: how to use rank function in sql

BY LOVE SINGH,
Here, name and id is the column name of the table tbltest.

SELECT
	name,
	RANK () OVER ( 
		ORDER BY id DESC
	) price_rank 
FROM
	tbltest;