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 vote90 views1 answer
How to get last client id sql
SQL
0 vote134 views2 answers
Update all linkedserver tables with openquery on db
SQL
1 vote127 views1 answer
How refresh navicat tables to see new tables
SQL
5 votes143 views2 answers
Mysql import gzip db
SQL
0 vote144 views1 answer
Sparql list all graphs
SQL
0 vote141 views1 answer
Import sql in postgresql
SQL
1 vote135 views1 answer
Oracle sql listagg
SQL
0 vote136 views1 answer
Add timestamp column to existing table ms sql server
SQL
0 vote131 views1 answer
Mysql start of today
SQL
14 votes131 views2 answers
How to auto increment in sql
SQL