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

Try using the below code:

SELECT MAX( col )

  FROM table

 WHERE col < ( SELECT MAX( col )

                 FROM table )