What is the simplest SQL Query to find the second largest value?

Question

What is the simplest SQL query to find the second largest integer value in a specific column? There are maybe duplicate values in the column.

Answer 1

To get the second largest value, you need to sort the associated column in descending order and apply LIMIT and OFFSET together as follows:

SELECT * FROM Customers Order By CustomerID Desc

Limit 1 Offset 2;

And here is another way of fetching the second largest value in SQL Server.

SELECT * FROM Customers Order By CustomerID Desc

Offset 1 Rows Fetch Next 1 Rows Only;