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 vote191 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote185 views1 answer
Mysql get date diff in months
SQL
1 vote175 views2 answers
Oracle list service names
SQL
0 vote219 views1 answer
Parent and child link in mysql
SQL
4 votes163 views3 answers
Mysql update with join
SQL
2 votes226 views2 answers
Postgres drop column if exists
SQL
0 vote178 views2 answers
Homebrew nysql launch
SQL
2 votes189 views1 answer
Query to find table size in oracle 12c
SQL
0 vote168 views1 answer
Sql case when exists in another table
SQL
2 votes166 views1 answer
Oracle number to percentage
SQL