Domanda di colloquio di Macquarie Group

SQL - how to get the 3rd item when there are items with the same value.