Pergunta de entrevista da empresa Oracle

SQL query on finding the second highest temp in a table