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

0 vote269 views1 answer
Sql not exists
SQL
-1 vote264 views3 answers
Update mongodb version ubuntu
SQL
0 vote276 views1 answer
Psql attribute cannot login
SQL
2 votes251 views1 answer
Match in sql server
SQL
0 vote260 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
12 votes277 views4 answers
Mysql get date difference in hours
SQL
15 votes284 views4 answers
Export mysql db using command line
SQL
0 vote336 views1 answer
Oracle convert int to date
SQL
1 vote264 views1 answer
Return size of tables in mysql
SQL
2 votes292 views1 answer
Mysql create user with remote access
SQL