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 vote242 views1 answer
Sql count how many times a value appears
SQL
0 vote316 views1 answer
T-sql email validation
SQL
3 votes312 views1 answer
Get current month last date in sql server
SQL
1 vote295 views1 answer
Postgres set column equal to another
SQL
4 votes293 views2 answers
Oracle default date format
SQL
0 vote279 views1 answer
Replace sqlalchemy
SQL
8 votes288 views1 answer
Mac restore mysql database command line
SQL
0 vote297 views1 answer
Alter fedora mysql 8.0 user
SQL
0 vote284 views1 answer
Tsql cmd exec script from file
SQL
1 vote288 views1 answer
Postgres delete from where date is greater than specific date
SQL