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 vote174 views1 answer
Max mysql
SQL
-1 vote213 views4 answers
Sql view postgresql
SQL
0 vote180 views1 answer
Full outer join in mariadb mysql
SQL
0 vote157 views1 answer
Show specific events on mysql
SQL
0 vote170 views1 answer
MySQL - Enabling the Event Scheduler
SQL
1 vote216 views2 answers
Laravel jwt generate token
SQL
0 vote161 views1 answer
Raiserror nowait sql server
SQL
1 vote218 views1 answer
Add time to date sql
SQL
1 vote179 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
1 vote195 views1 answer
Difference between where and having clause
SQL