SQL Second-Highest Margin Call | Dataford Interview Questions

Write a SQL query to find the second-highest margin call amount from a transactions database.

Use the transactions table and treat duplicate margin call amounts as one value. Exclude non-margin-call transactions and rows where the amount is missing.

Output

Return at most one row with the column second_highest_margin_call_amount.
Return the second-highest distinct amount, or no row if fewer than two distinct amounts exist.

Schema

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
transaction_type	VARCHAR(30)	Transaction classification
amount	DECIMAL(12,2)	Margin call or transaction amount
transaction_date	DATE	Date the transaction was recorded

Your question is SQL Second-Highest Margin Call. 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