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 vote129 views2 answers
Postgres autoincrement primary key
SQL
0 vote136 views1 answer
Postgres in operator with comma separated values
SQL
0 vote135 views1 answer
How to import sqlite driver class in java using maven
SQL
0 vote133 views1 answer
MySQL error code 2068
SQL
6 votes133 views2 answers
Stored procedure to delete data from table in mysql
SQL
0 vote124 views1 answer
Mysql change default collation
SQL
11 votes140 views1 answer
Creating tables in sql with python
SQL
0 vote201 views1 answer
Mariadb date equals to current_date plus days
SQL
3 votes133 views1 answer
Postgres count distinct
SQL
0 vote146 views2 answers
MySQL PARTITION BY month automatically
SQL