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 vote138 views1 answer
Select lowest values sql
SQL
0 vote94 views1 answer
Mysql timeout 30 seconds
SQL
5 votes126 views6 answers
Sql add days to date
SQL
3 votes137 views1 answer
V$session not found in oracle
SQL
7 votes160 views1 answer
Show line number in sql server
SQL
6 votes131 views2 answers
Mysql check auto increment value
SQL
0 vote129 views1 answer
Sql change date format
SQL
9 votes130 views3 answers
Oracle undo usage by session
SQL
0 vote124 views1 answer
How to export table data from mysql table in sql format
SQL
13 votes125 views4 answers
What is sql
SQL