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 vote114 views1 answer
Insert into select with group by
SQL
0 vote101 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
2 votes107 views4 answers
Mysql get all tables row count
SQL
1 vote107 views3 answers
Divide by zero error in sql
SQL
0 vote114 views1 answer
Oracle show grants on table
SQL
1 vote85 views1 answer
Oracle sql assign unique number to each grouping
SQL
0 vote96 views1 answer
Get sum sqlite android
SQL
1 vote102 views1 answer
Check message id sql server
SQL
0 vote96 views2 answers
Pop sql insert value into
SQL
0 vote101 views1 answer
Inner join distinct
SQL