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

16 votes253 views6 answers
Python sqlite
SQL
6 votes204 views2 answers
Drop foreign key
SQL
16 votes220 views1 answer
Mssql int max value
SQL
0 vote248 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote190 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
15 votes181 views7 answers
MYSQL
SQL
0 vote235 views1 answer
Mariadb alter table add column if not exists example
SQL
1 vote218 views1 answer
How to delay stored procedure execution in sql server
SQL
1 vote313 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
2 votes210 views6 answers
Mysql change timezone
SQL