Pergunta de entrevista da empresa IQVIA

Regarding query. Get 2nd highest value in a table.