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

7 votes294 views2 answers
Oracle foreign key reference table
SQL
1 vote204 views1 answer
Oracle create as select
SQL
1 vote203 views1 answer
Oracle first row
SQL
0 vote205 views5 answers
Mode sql course
SQL
3 votes211 views1 answer
Oracle list invalid password ORA-01017
SQL
0 vote195 views1 answer
Start and stop mysql
SQL
0 vote208 views1 answer
Mariadb mysql root access denied
SQL
1 vote209 views1 answer
Display total number of tables in mysql
SQL
1 vote229 views2 answers
Oracle 18c xe ORA-65096
SQL
2 votes231 views4 answers
How to find 2nd highest salary in mysql
SQL