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 vote183 views2 answers
How to type a blank discord messgae
SQL
4 votes148 views1 answer
Sql delete where in select
SQL
0 vote159 views1 answer
Order by with where clause in mysql
SQL
0 vote161 views1 answer
Create table in dbms cmds
SQL
0 vote152 views1 answer
Sql get user account
SQL
0 vote180 views2 answers
Nested query
SQL
0 vote158 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
1 vote146 views1 answer
Mysql count all table rows
SQL
10 votes159 views4 answers
SELECT FROM WHERE
SQL
2 votes198 views1 answer
Show max_allowed_packet mysql
SQL