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 vote204 views1 answer
Start and stop mysql
SQL
2 votes224 views1 answer
Search query in mysql
SQL
0 vote197 views1 answer
Version and edition of SQL Server Database Engine
SQL
0 vote201 views1 answer
Mysql query with sql to get the next row
SQL
0 vote204 views1 answer
Sql column as header
SQL
0 vote205 views1 answer
SQL Server Altering Column to be Unique
SQL
3 votes221 views1 answer
Oracle drop user
SQL
0 vote198 views1 answer
How to use query in nosql
SQL
0 vote201 views1 answer
Select in select sql
SQL
6 votes201 views1 answer
Postgresql add enum value
SQL