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

Question

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

Answer 1

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.