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 vote239 views1 answer
Mysql url
SQL
0 vote231 views1 answer
Select true if exists on another table or false sqlserver
SQL
0 vote225 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
0 vote184 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
0 vote218 views1 answer
Enable sql server full text indexing
SQL
0 vote213 views1 answer
Original Query
SQL
0 vote215 views1 answer
SQL Server Altering Column to be Unique
SQL
14 votes226 views4 answers
Remove record from table sql
SQL
5 votes213 views2 answers
Sql conn
SQL
0 vote228 views2 answers
PostgreSQL having
SQL