Question d’entretien chez Macquarie Group

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