What is the simplest SQL Query to find the second largest value?
SELECT MAX(col) FROM table WHERE col < (SELECT MAX(col) FROM table)
SELECT MAX(col) FROM table WHERE col NOT IN (SELECT MAX(col) FROM table);
What is the simplest SQL Query to find the second largest value?
SELECT MAX(col) FROM table WHERE col < (SELECT MAX(col) FROM table)
SELECT MAX(col) FROM table WHERE col NOT IN (SELECT MAX(col) FROM table);