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 vote213 views1 answer
Call function in query sql server
SQL
0 vote233 views1 answer
Parent and child link in mysql
SQL
0 vote191 views1 answer
Sql remove last 2 digit
SQL
0 vote210 views2 answers
Identity syntax in sql
SQL
0 vote199 views1 answer
Sql bild in function
SQL
0 vote179 views1 answer
How to output a different column name in mysql
SQL
0 vote200 views1 answer
Can sqldatareader be null
SQL
0 vote253 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote250 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote210 views1 answer
.sql File Run in PSQL
SQL