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

-1 vote313 views3 answers
SQL MM/dd/yyyy format
SQL
0 vote288 views1 answer
Sql query for select from specific columns in a table
SQL
0 vote260 views1 answer
How to check oracle index table
SQL
0 vote289 views1 answer
Oracle query to see what scema i am working in
SQL
1 vote328 views2 answers
Sql split string by space
SQL
1 vote303 views1 answer
Adding a check statement in sql
SQL
0 vote321 views1 answer
Sql change column in existing table
SQL
0 vote311 views1 answer
C# mysql update statement set value to null
SQL
1 vote289 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
0 vote347 views1 answer
Sql find gaps in date ranges
SQL