What is the simplest SQL Query to find the second largest value?
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 )