Sql select second max

Both options you find max as a subset and then exclude from main select
sql> SELECT MAX( col ) FROM table
 	WHERE col < ( SELECT MAX( col ) FROM table);
sql> SELECT MAX(col) FROM table 
WHERE col NOT IN (SELECT MAX(col) FROM table);

Source: stackoverflow.com

Similar codes

-1 vote355 views1 answer
Sql oracle take only last results
SQL
0 vote446 views1 answer
Current month transactions in mysql
SQL
0 vote341 views1 answer
Composit key in sql
SQL
4 votes355 views4 answers
Sqlite describe table
SQL
0 vote451 views2 answers
Sqlalchemy default value for column
SQL
0 vote374 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
0 vote333 views1 answer
Stop psql server windows
SQL
0 vote303 views1 answer
Mysqli or pdo
SQL
0 vote383 views1 answer
Mysql record group by created date count
SQL
21 votes361 views6 answers
Change column in mysql
SQL