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 votes106 views1 answer
Oracle create directory
SQL
0 vote120 views3 answers
Delete in SQL SERVER
SQL
0 vote104 views1 answer
Parsing float to int in mysql
SQL
0 vote106 views1 answer
Microsoft sql server python connection
SQL
0 vote110 views1 answer
Enable outgoing remote MySQL access
SQL
4 votes120 views1 answer
Describe table mysql
SQL
0 vote105 views2 answers
Nosqlbooster query other collection
SQL
3 votes114 views1 answer
Force using index plsql
SQL
1 vote107 views1 answer
Index a database column sql
SQL
0 vote121 views1 answer
How to get nth number in sql
SQL