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.

46 Answers
46

SELECT MAX( col )
  FROM table
 WHERE col < ( SELECT MAX( col )
                 FROM table )

Tags:

Leave a Reply

Your email address will not be published. Required fields are marked *