Domanda di colloquio di Cognizant

Write a query to select 3rd highest valued record.