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

3 votes227 views1 answer
Apex set debug level
SQL
0 vote238 views1 answer
Sql server convert to guid
SQL
0 vote219 views1 answer
Pip install mysqlclient error
SQL
0 vote222 views1 answer
T-sql check if data exists
SQL
0 vote238 views1 answer
MySQL update with subquery
SQL
0 vote223 views1 answer
Contraint default SQL
SQL
0 vote232 views1 answer
How to to get time in sql
SQL
1 vote219 views1 answer
Delete mysql from mac
SQL
0 vote233 views1 answer
Sql server sleep
SQL
0 vote212 views1 answer
Get created time of database psql 8
SQL