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 vote132 views1 answer
Date in where on datetime column clause mysql
SQL
0 vote130 views1 answer
Group by two columns postgres
SQL
0 vote123 views1 answer
How to export table data from mysql table in sql format
SQL
-1 vote140 views1 answer
Capitole toulouse
SQL
0 vote121 views3 answers
Average salary in sql
SQL
0 vote141 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote128 views1 answer
Oracle list datafiles
SQL
0 vote116 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
0 vote131 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
-2 votes182 views1 answer
Trunc in sql
SQL