Pergunta de entrevista da empresa Capgemini

How would you select the second highest value using SQL query?