Ranks Vs Dense Rank

SQL RANK vs DENSE_RANK top usage

SQL Rank function vs Dense_rank explained the usage with real examples