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 vote367 views1 answer
Sql datum formatieren
SQL
0 vote151 views1 answer
Get who is hired in january in sql
SQL
1 vote146 views1 answer
How to run sql script
SQL
3 votes105 views1 answer
How to get list of synonyms in oracle
SQL
0 vote164 views1 answer
Drop view in mysql
SQL
0 vote144 views1 answer
Oracle 11g forget password
SQL
17 votes166 views3 answers
Postgresql version command
SQL
0 vote171 views2 answers
Mysql missin expression near on
SQL
3 votes158 views3 answers
Postgresql random number
SQL
1 vote169 views1 answer
Psql human readable
SQL