row_number(), rank(), and dense_rank() are SQL functions used for ranking and ordering data.

• row_number() assigns a unique number to each row in the result set.

• rank() assigns a unique rank to each row,...read more