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 vote339 views1 answer
Oracle list chain steps
SQL
7 votes408 views1 answer
Oracle pagination query rownum
SQL
11 votes399 views1 answer
Creating tables in sql with python
SQL
0 vote380 views1 answer
Default order by in mysql
SQL
7 votes374 views4 answers
Lowest salary in sql
SQL
3 votes353 views4 answers
Mysql delete duplicate rows
SQL
8 votes381 views2 answers
Phpmyadmin default password
SQL
1 vote364 views1 answer
Oracle user last connected
SQL
5 votes366 views3 answers
Oracle first day of last year
SQL
0 vote387 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL