<p>What is the simplest SQL query to find the second largest integer value in a specific column? </p>

<p>There are maybe duplicate values in the column.</p>

The easiest would be to get the second value from this result set in the application:
```
```
SELECT DISTINCT value 
FROM Table 
ORDER BY value DESC 
LIMIT 2
```
```
But if you must select the second value using SQL, how about:
```
```
SELECT MIN(value) 
FROM ( SELECT DISTINCT value 
       FROM Table 
       ORDER BY value DESC 
       LIMIT 2
     ) AS t
```
```