Second-Highest Value Without LIMIT | Dataford Interview Questions

Write a SQL query to find the second-highest loan disbursement amount from a transactions table without using the LIMIT clause for Navi.

Use the transactions table and consider only rows whose transaction type is DISBURSEMENT. The result should identify the second-highest distinct amount, ignoring NULL values and duplicate amounts.

Output

Return one row with the column second_highest_disbursement.
Return the second-highest distinct disbursement amount, or NULL if fewer than two distinct amounts exist.

Schema

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
transaction_type	VARCHAR(20)	Transaction classification
amount	NUMERIC(14,2)	Transaction amount in the account currency

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

Write a SQL query to find the second-highest loan disbursement amount from a transactions table without using the LIMIT clause for Navi.

Output

Return one row with the column second_highest_disbursement.
Return the second-highest distinct disbursement amount, or NULL if fewer than two distinct amounts exist.

Schema

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
transaction_type	VARCHAR(20)	Transaction classification
amount	NUMERIC(14,2)	Transaction amount in the account currency

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