DSIE 6.3.4 second highest sale

There are several ways to to solve this problem.

SELECT sale FROM sales ORDER BY sale DESC LIMIT 1 OFFSET 1;
SELECT MAX(sale)
FROM sales
WHERE sale NOT IN (SELECT MAX(sale) FROM sales);
SELECT MAX(sale)
FROM sales
WHERE sale < (SELECT MAX(sale) FROM sales);
SELECT DISTINCT sale
FROM sales a
WHERE 2 = (SELECT COUNT(DISTINCT sale)
FROM sales b
WHERE a.sale <= b.sale);
One clap, two clap, three clap, forty?

By clapping more or less, you can signal to us which stories really stand out.