SQL Second-Highest Traffic Query | Dataford Interview Questions

Write a SQL query to find the second-highest traffic volume recorded in a network connection log table.

Return the second-highest distinct value. If multiple records have the same traffic volume, treat them as one value. Ignore records where the traffic volume is NULL.

Output

Return one row with the column second_highest_traffic_volume
Return NULL if no second-highest distinct value exists

Schema

network_connection_logs

Column	Type	Description
connection_idPK	INT	Unique identifier for the connection log record
traffic_volume	BIGINT	Recorded traffic volume for the connection
source_ip	VARCHAR(45)	Source IP address associated with the connection
connection_status	VARCHAR(20)	Connection outcome status
recorded_at	TIMESTAMP	Timestamp when the traffic was recorded

Your question is SQL Second-Highest Traffic Query. 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