Second-Highest Value Without LIMIT

MediumSQL · PostgreSQL

Problem

Write a SQL query to find the second-highest value in a table without using LIMIT.

Use the measurements table and its value column. Treat duplicate values as one distinct value. If fewer than two distinct non-null values exist, the query should return NULL.

Output

Return one row with the column second_highest_value.
Include the second-highest distinct non-null value.
Return NULL when no such value exists.

Schema

measurements

Column	Type	Description
measurement_idPK	INT	Unique measurement identifier
value	NUMERIC(10,2)	Measured numeric value

Tablesmeasurements

CodePostgreSQL

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

Run your query to see results here.