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.

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

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.