Capgemini interview question

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