Barclays Interview Question

What are of Ranks in SQL and what are their uses?