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

13 votes163 views6 answers
Mysql update from select
SQL
7 votes257 views1 answer
Oracle alter sequence restart start with
SQL
0 vote214 views1 answer
Install squirrel sql ubuntu
SQL
0 vote191 views1 answer
Sql statement show all emails with dome
SQL
0 vote179 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
0 vote166 views1 answer
How to move a columns location in mysql
SQL
6 votes283 views1 answer
Sql insert values into table
SQL
0 vote176 views1 answer
Create column that already exists mysql
SQL
3 votes167 views2 answers
Update Query in SQL Server
SQL
0 vote224 views1 answer
How to compile a function in oracle
SQL