HSBC interview question

Row rank function in sql