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 vote135 views1 answer
What is between operator
SQL
1 vote151 views2 answers
Logical operators in sql
SQL
4 votes141 views2 answers
Oracle set date format
SQL
0 vote152 views1 answer
Is not numeric sql
SQL
0 vote145 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
0 vote149 views1 answer
Sql select column name like from multiple tables
SQL
8 votes127 views2 answers
Phpmyadmin password
SQL
0 vote135 views1 answer
Oracle query archive mode
SQL
-1 vote139 views1 answer
Condition in orderby mysql
SQL
0 vote149 views1 answer
Get cpu details sql
SQL