Interview Guides Experiences

Interview Guides

All questions/SQL & Data Manipulation

Asked 1mo ago|

Xero

Xero

Second-Highest Transaction Amount Query

Medium

SubqueriesRankingsalary

Problem

Task

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.

Problem

Task

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.

Practice SQL

PostgreSQL

Open on desktop for the full SQL editor with syntax highlighting and autocomplete.

Up next

The Ameriprise

Second-Highest Client Transaction AmountMedium

Teradata

Second-Highest Segment Transaction ValueMedium

Cobblestone Energy

Second Highest Trader SalaryEasy

Second-Highest Transaction Amount Query | Dataford Interview Questions