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

3 votes218 views3 answers
Update con select postgresql
SQL
1 vote196 views1 answer
Check message id sql server
SQL
0 vote263 views1 answer
Call function sql oracle with output put line
SQL
3 votes211 views1 answer
Force using index oracle
SQL
0 vote236 views1 answer
SQL Cut part string
SQL
3 votes195 views1 answer
Kill mysql processlist in whose time more than 200
SQL
0 vote212 views1 answer
Format the money fied with comma in international system using sql
SQL
1 vote214 views1 answer
Sql group by sum with condition
SQL
0 vote218 views1 answer
Comma seperated join mssql
SQL
18 votes191 views4 answers
Mysql current date between two dates
SQL