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 vote144 views1 answer
Mysql update privileges
SQL
2 votes128 views1 answer
Oracle index size calculation
SQL
0 vote132 views1 answer
Min mysql
SQL
0 vote137 views1 answer
Call object contructor and call methods of object
SQL
1 vote155 views1 answer
Apex select list ORA-20999
SQL
0 vote145 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
0 vote140 views1 answer
Power query datetime to date
SQL
0 vote129 views1 answer
Sql comparison operators
SQL
3 votes147 views2 answers
Postgres alter table owner
SQL
0 vote124 views1 answer
Oracle DROP PROGRAM
SQL