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 vote127 views1 answer
Sql column as header
SQL
8 votes141 views1 answer
Oracle search stored procedures for text
SQL
5 votes92 views1 answer
Alter table default value mysql
SQL
1 vote119 views1 answer
Mysql get character set
SQL
1 vote158 views2 answers
Install sql server management studio ubuntu
SQL
0 vote84 views1 answer
Sql count how many times a value appears
SQL
4 votes134 views3 answers
Sql drop primary key
SQL
10 votes161 views1 answer
Oracle all_dependencies
SQL
7 votes150 views2 answers
Create index mysql cli
SQL
0 vote171 views1 answer
Oracle plsql sleep
SQL