Second-Highest Price Without LIMIT | Dataford Interview Questions

Write a query to identify the second-highest property price from a table without using the LIMIT clause.

Use the properties table and consider only non-NULL prices. The result should represent the second-highest distinct price, including duplicate prices only once.

Output

Return one row with one column named second_highest_price.
Return the second-highest distinct non-NULL price.

Schema

properties

Column	Type	Description
property_idPK	INT	Unique property identifier
address	VARCHAR(255)	Property street address
price	NUMERIC(12,2)	Listed property price

Your question is Second-Highest Price Without LIMIT. 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