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

5 votes151 views6 answers
In operator sql
SQL
0 vote131 views1 answer
Deny select insert update delete sql
SQL
13 votes215 views4 answers
Mysql remove foreign key constraint
SQL
2 votes139 views1 answer
How to find constraints on a table in oracle
SQL
1 vote133 views2 answers
How to check username in mysql command line
SQL
8 votes142 views1 answer
Oracle add months to sysdate
SQL
0 vote191 views1 answer
Add week ending date sql server
SQL
0 vote214 views1 answer
How to update random rows in sql
SQL
3 votes144 views1 answer
Postgresql db owner change
SQL
16 votes161 views3 answers
Get count of duplicate records
SQL