Second-Highest Donation Query | Dataford Interview Questions

Write a query to find the second-highest donation amount from a table of transaction records, handling potential duplicate values.

Treat duplicate donation amounts as one distinct value and exclude records without a donation amount.

Output

Return at most one row with a column named second_highest_donation.
Return the second-highest distinct donation amount, or no row if fewer than two distinct non-NULL amounts exist.

donation_transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
donation_amount	NUMERIC(12,2)	Donation amount recorded for the transaction
transaction_date	DATE	Date of the transaction

Your question is Second-Highest Donation 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.

Write a query to find the second-highest donation amount from a table of transaction records, handling potential duplicate values.

Treat duplicate donation amounts as one distinct value and exclude records without a donation amount.

Return at most one row with a column named second_highest_donation.
Return the second-highest distinct donation amount, or no row if fewer than two distinct non-NULL amounts exist.

donation_transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
donation_amount	NUMERIC(12,2)	Donation amount recorded for the transaction
transaction_date	DATE	Date of the transaction

Your question is Second-Highest Donation 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.