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 vote291 views1 answer
Retrieve meaning
SQL
11 votes253 views2 answers
Sql between date range
SQL
23 votes300 views4 answers
Uninstall postgresql ubuntu
SQL
0 vote226 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
1 vote279 views1 answer
Check if mysql is installed
SQL
20 votes305 views6 answers
Change password in mysql
SQL
0 vote277 views1 answer
Show database not empty tables postgres
SQL
0 vote275 views1 answer
Excute raw query
SQL
5 votes276 views2 answers
Postgre insert select
SQL
0 vote292 views1 answer
Tsql delete all rows
SQL