Query to get 3rd largest amount and 2nd largest amount from table

sql

Solution

SELECT ... FROM ... ORDER BY column DESC LIMIT 2 OFFSET 1;

Depending on your SQL dialect there's a different way of specifying LIMIT and OFFSET.

Problem

How to find 2nd and 3rd largest amount from a table

Original source