Gartner Interview Question

A sql query which involves the use of RANK.