Select second largest value in a column using SQL

The answer is pretty simple without jumping over hoops or thinking about taking MAX etc. SELECT value FROM table ORDER BY value DESC LIMIT 1,1

Why LIMIT 1,1 ? Shouldnt it be 2,1

Think again. LIMIT 0,1 is the first record. 12 May, 2010
Comments (0)
You may also like
On Facebook
Email Newsletter