how to find second the second maximum in a column using a subquery

Question

subquery

Answer 1

select Max(columna) as secondmax from table where columna not in ( select Max(columna) from table);

Answer 2

jose's answer is correct, you can also try,

SELECT column FROM table WHERE column < MAX(column) ORDER BY column DESC LIMIT 1;

Answer 3

SELECT column FROM table WHERE column < MAX(column) ORDER BY column DESC LIMIT 1;

Answer 4

YouStupidFuckingBitch