ZS Associates Interview Question

How are ranks used in SQL