View Single Post
  #4 (permalink)  
Old 08-30-2006, 11:25 AM
Anonymous
 
Posts: n/a
Default SQL 92 answer. Re: How to find second highest value of a column in a table? | SQL?

[sql]
SELECT score FROM scores WHERE 1 ORDER BY score DESC LIMIT 1,1
[/sql]
Edit/Delete Message Reply With Quote