Second-Highest Transaction Amount Query | Dataford Interview Questions

You are given a transaction table from an Infosys Finacle-style payments dataset. Write a PostgreSQL query to return the second-highest distinct transaction amount without using the LIMIT clause. If the highest amount appears multiple times, it should still count as one distinct value, so the query must return the next lower distinct amount.

Output details

Return one column named second_highest_amount.
Treat NULL amounts as excluded and return NULL when no lower distinct amount exists.

Schema

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
account_id	INT	Account associated with the transaction
transaction_type	VARCHAR(20)	Type of transaction
amount	DECIMAL(10,2)	Transaction amount
transaction_date	DATE	Date of the transaction

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

Output details

Return one column named second_highest_amount.
Treat NULL amounts as excluded and return NULL when no lower distinct amount exists.

Schema

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
account_id	INT	Account associated with the transaction
transaction_type	VARCHAR(20)	Type of transaction
amount	DECIMAL(10,2)	Transaction amount
transaction_date	DATE	Date of the transaction

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