Pregunta de entrevista de Capgemini

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