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 vote150 views1 answer
What is a Database?
SQL
0 vote152 views1 answer
Enable Rabbitmq management plugin
SQL
6 votes145 views2 answers
If not exists insert sql
SQL
0 vote145 views1 answer
Make a socket server to detect changes in mysql
SQL
1 vote153 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
14 votes143 views2 answers
How to auto increment in sql
SQL
40 votes228 views4 answers
PostgreSQL add column
SQL
1 vote112 views1 answer
Convert money to varchar sql server
SQL
23 votes167 views6 answers
Create table sql server
SQL
8 votes176 views2 answers
Python simple connect to mysql
SQL