Question d’entretien chez Cognizant

Write a query to select 3rd highest valued record.