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 vote162 views2 answers
How to generate a unique random number in mysql
SQL
0 vote150 views1 answer
RowDataPacket
SQL
0 vote181 views2 answers
Php convert dbf to mysql
SQL
2 votes159 views2 answers
Laravel query builder toSql
SQL
4 votes163 views6 answers
List all tables in postgres
SQL
13 votes112 views2 answers
Oracle all source
SQL
0 vote188 views1 answer
Sql query to find percentage of null values in a table
SQL
-1 vote151 views2 answers
Postgresql user permissions to database
SQL
0 vote156 views1 answer
Windows services sql
SQL
0 vote157 views1 answer
Sql server alter table add column tinyint
SQL