What does DENSE_RANK() return for tied rows compared to RANK()?

Question

SQL Data Analyst — Medium

What does DENSE_RANK() return for tied rows compared to RANK()?

Accepted Answer

DENSE_RANK() returns the same rank for tied rows but does not skip subsequent rank numbers, unlike RANK(). This means that tied rows will have the same rank value, but the next row will not skip a rank number.