Pregunta de entrevista de ZS Associates

How are ranks used in SQL