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 vote216 views1 answer
Sub query in linq
SQL
0 vote209 views1 answer
Drop unique
SQL
1 vote193 views1 answer
Delete mysql from mac
SQL
0 vote204 views1 answer
Get clob size oracle
SQL
4 votes193 views3 answers
Create database in mySQL
SQL
3 votes214 views3 answers
Mysql select table names
SQL
0 vote275 views2 answers
Uninstall postgresql mac
SQL
0 vote392 views1 answer
Multiple row join
SQL
3 votes224 views1 answer
Oracle list privileges
SQL
0 vote198 views1 answer
ORACLE SUBSTRING SYNTAX
SQL