Capgemini Interview Question

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