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
Related Searches
right click your address bar and select paste and hit enter.
Comments (0)
You may also like
Popular Posts
Recent Posts
Tags
Random photo
Havelock Boat Jetty Havelock Boat Jetty in Havelock Island Andaman
On Facebook
Email Newsletter
Recent Comments
digitalpbk