SQL: Second Highest Value | Dataford Interview Questions

How would you get the second highest value from a table in DBMS?

Write a PostgreSQL query that returns the second highest distinct non-null value from the records table. Duplicate values should count once, and return NULL when a second distinct value does not exist.

Output

One row with the column second_highest_value
Include the second highest distinct non-null value from records
Return the value as NULL if no second distinct value exists

Schema

records

Column	Type	Description
record_idPK	INT	Unique identifier for the record
value	NUMERIC(10,2)	Value used to determine the ranking

Your question is SQL: Second Highest Value. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

How would you get the second highest value from a table in DBMS?

Output

One row with the column second_highest_value
Include the second highest distinct non-null value from records
Return the value as NULL if no second distinct value exists

Schema

records

Column	Type	Description
record_idPK	INT	Unique identifier for the record
value	NUMERIC(10,2)	Value used to determine the ranking

Your question is SQL: Second Highest Value. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.