Cognizant interview question

Write a query to select 3rd highest valued record.