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 vote203 views2 answers
How to get last inserted id in sql server c#
SQL
3 votes285 views2 answers
How to modify rows in SQL Server
SQL
0 vote200 views1 answer
Sql auto_increment syntax
SQL
0 vote194 views1 answer
Sql server port 1434
SQL
0 vote350 views2 answers
Create fulltext index mysql
SQL
0 vote158 views1 answer
Copy table dbeaver
SQL
0 vote192 views1 answer
How to order result of subquery in select
SQL
6 votes200 views2 answers
Mysql first day of month
SQL
40 votes266 views6 answers
Update table mysql
SQL
0 vote227 views1 answer
Database db connection string format
SQL