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 vote151 views1 answer
T-sql delete view if exists
SQL
0 vote107 views1 answer
Alasql delete column
SQL
0 vote106 views1 answer
Wordpress database query change url
SQL
0 vote119 views1 answer
Foreign key multiple columns
SQL
12 votes153 views4 answers
How to drop all tables in postgresql
SQL
0 vote109 views4 answers
Database stuck at restoring state
SQL
0 vote257 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
1 vote105 views1 answer
Create temporal table in sql
SQL
0 vote103 views1 answer
Where case insensitive like mysql
SQL
1 vote110 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL