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

20 votes205 views6 answers
Creating a table in sql
SQL
0 vote179 views1 answer
Gcloud check sql
SQL
0 vote183 views1 answer
Grepper sql workbench download
SQL
0 vote197 views1 answer
Sqlite löschen einer tabelle
SQL
-1 vote185 views1 answer
Sql syntax create timestamp column
SQL
1 vote194 views1 answer
Update from select oracle
SQL
-1 vote191 views1 answer
Can pandas fetch data from sql
SQL
6 votes216 views2 answers
Mysqldump password in file
SQL
0 vote190 views1 answer
Convert sql server guid to varbinary
SQL
7 votes180 views1 answer
Append column sql
SQL