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 vote263 views1 answer
Show specific events on mysql
SQL
-1 vote177 views1 answer
Mysql how to set update or create
SQL
2 votes230 views1 answer
Alter table add multiple columns postgresql
SQL
1 vote227 views1 answer
Mysql random limit 1
SQL
0 vote228 views1 answer
Concat column value of same user in mysql
SQL
0 vote224 views1 answer
Oracle create package body
SQL
1 vote243 views2 answers
Sql queries practice
SQL
0 vote254 views1 answer
Oracle drop type
SQL
0 vote256 views1 answer
Update sql sintax
SQL
22 votes226 views2 answers
Mysql show all tables
SQL