Second-Highest Per Region Query

MediumSQL · PostgreSQL

Problem

Write a SQL query to return the second-highest value in each region using window functions.

Use the regional_values table. Return only regions with at least two distinct non-null values. If multiple records share the second-highest value, return that value once.

Output

One row per qualifying region, with columns region and second_highest_value.
Sort the results by region in ascending order.

Schema

regional_values

Column	Type	Description
value_idPK	INT	Unique identifier for the regional value record
region	VARCHAR(50)	Region associated with the value
metric_value	DECIMAL(12,2)	Numeric value to rank within each region

Tablesregional_values

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.