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

2 votes188 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote195 views1 answer
Mysql regex select
SQL
1 vote183 views1 answer
Oracle avg
SQL
19 votes185 views6 answers
Laravel sql query
SQL
2 votes187 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote362 views1 answer
Install mysql on bash
SQL
1 vote250 views1 answer
Postgres select as csv
SQL
9 votes205 views3 answers
Mysql run sql file
SQL
12 votes177 views3 answers
Install sqlite driver ubuntu
SQL
6 votes187 views1 answer
What is where clause in sql
SQL