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 votes297 views2 answers
Get number of columns sql
SQL
5 votes301 views5 answers
Sqlite install python
SQL
5 votes294 views1 answer
Oracle nls instance
SQL
0 vote480 views1 answer
The differnece between to values in sql
SQL
0 vote308 views1 answer
Select place default lat long
SQL
24 votes293 views6 answers
Rename a column in sql server
SQL
3 votes293 views2 answers
Postgres alter table owner
SQL
0 vote287 views1 answer
Sql server union if table exist
SQL
1 vote278 views1 answer
Show table columns
SQL
0 vote279 views1 answer
T-sql check if data exists
SQL