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 vote361 views1 answer
Backup mysql schema only
SQL
3 votes336 views1 answer
Oracle sleep
SQL
0 vote413 views1 answer
How to subquey to do not load in live database in
SQL
6 votes362 views2 answers
Mysql convert timestamp to date
SQL
12 votes325 views1 answer
Psql drop column
SQL
1 vote328 views1 answer
Mysql how to reset primary key
SQL
2 votes359 views2 answers
Sqlalchemy return id after insert
SQL
0 vote312 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
15 votes317 views4 answers
Pl sql
SQL
0 vote326 views1 answer
Mysql update even / odd rows
SQL