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 vote188 views1 answer
Sql find leading space
SQL
1 vote225 views1 answer
Sql select sum group by id laravel
SQL
0 vote206 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
14 votes270 views1 answer
How to export db from mysql
SQL
2 votes219 views2 answers
Python escape string for sql
SQL
0 vote205 views1 answer
Python mysql show databases
SQL
0 vote198 views1 answer
Group by two columns postgres
SQL
0 vote209 views1 answer
Mysql milliseconds
SQL
0 vote183 views1 answer
Recursive query herarchical data sql server
SQL
0 vote189 views1 answer
Mysqlimport
SQL