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

3 votes137 views1 answer
Oracle revoke grant
SQL
0 vote154 views1 answer
Creating a simple notify in postgresql
SQL
2 votes156 views1 answer
Sql get the name of user pc
SQL
0 vote159 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
1 vote184 views1 answer
Oracle check table lock
SQL
11 votes145 views1 answer
How to get ddl for materialized view
SQL
1 vote138 views1 answer
$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
SQL
7 votes154 views2 answers
Create mysql user
SQL
4 votes143 views1 answer
Change nls_date_format
SQL
0 vote170 views1 answer
C# select Mysql
SQL