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 vote110 views3 answers
Psql get last rows
SQL
0 vote53 views1 answer
Update row in sqlite python
SQL
1 vote96 views1 answer
Mysql drop key
SQL
0 vote157 views1 answer
Table structure in sql
SQL
1 vote101 views1 answer
Postgres set column equal to another
SQL
0 vote113 views1 answer
MySQL import data from large CSV file
SQL
0 vote167 views1 answer
Mysql disable triggers
SQL
0 vote123 views1 answer
Convert LDAP Epoch to Date
SQL
12 votes159 views2 answers
Update column data type postgres
SQL
1 vote180 views1 answer
Mysql data from file
SQL