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.

Answer 2

SQL Server 2000+

SELECT TOP 2
   *
FROM
   (
   SELECT TOP 3 * FROM table ORDER BY Something DESC
   ) T
ORDER BY Something

Answer 3

If you are using SQL Server 2005+ you can use the ROW_NUMBER construct.