What is the simplest SQL Query to find the second largest value?

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

More Related Contents:

  1. Refactor a PL/pgSQL function to return the output of various SELECT queries
  2. SQL – HAVING vs. WHERE
  3. Can I use CASE statement in a JOIN condition?
  4. sql server 2008 management studio not checking the syntax of my query
  5. dplyr left_join by less than, greater than condition
  6. How do I write a full outer join query in access
  7. Is there an Oracle SQL query that aggregates multiple rows into one row? [duplicate]
  8. Storing money in a decimal column – what precision and scale? [closed]
  9. Is there something like a zip() function in PostgreSQL that combines two arrays?
  10. Conditional sum in Group By query MSSQL
  11. Natural join in SQL Server
  12. Pivot using SQL Server 2000
  13. Transfer data from one database to another database
  14. How to update and order by using ms sql
  15. What does the “@” symbol do in SQL?
  16. Using Excel VBA to run SQL query
  17. Procedure or function !!! has too many arguments specified
  18. MySQL select where column is not empty
  19. Is it possible to have a default parameter for a mysql stored procedure?
  20. Postgres – Function to return the intersection of 2 ARRAYs?
  21. Split string and take last element
  22. Can I set ignore_dup_key on for a primary key?
  23. Built-in function to capitalise the first letter of each word
  24. BigQuery SQL for 28-day sliding window aggregate (without writing 28 lines of SQL)
  25. Convert String to Date in MS Access Query
  26. Difference between FULL JOIN & INNER JOIN
  27. Update multiple rows with one query?
  28. Is this a good way to model address information in a relational database?
  29. Using django how can I combine two queries from separate models into one query?
  30. Previous Monday & previous Sunday’s date based on today’s date

Leave a Comment