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.

Accepted Answer

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

Solution