Gartner interview question

A sql query which involves the use of RANK.