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

104 votes559 views2 answers
Like in mysql
SQL
0 vote363 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
0 vote338 views1 answer
Sqlalchemy case insensitive like
SQL
0 vote372 views1 answer
Mysql get hour from datetime
SQL
0 vote396 views1 answer
Postgres docs /copy metacomand
SQL
-1 vote424 views5 answers
Left join sql
SQL
1 vote345 views1 answer
Pagination sql
SQL
3 votes374 views2 answers
Order by postgresql
SQL
3 votes348 views3 answers
C# sql select
SQL
10 votes353 views1 answer
User_dependencies
SQL