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 vote170 views1 answer
Flask sqlalchemy update row
SQL
0 vote179 views1 answer
Get who is hired in month in sql
SQL
0 vote182 views1 answer
Search column name sql
SQL
0 vote177 views1 answer
Get first monday of month sql
SQL
0 vote189 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
0 vote183 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
0 vote185 views2 answers
Oracle sql for each row
SQL
0 vote172 views1 answer
Number(10 2) in sql means
SQL
9 votes186 views1 answer
Alter table column change data type to text mysql
SQL
0 vote236 views1 answer
Connect google bigquery connect using sqirrel
SQL