Pergunta de entrevista da empresa Cognizant

Write a query to select 3rd highest valued record.