ZS Associates interview question

How are ranks used in SQL