View Single Post
  #5 (permalink)  
Old 08-31-2006, 06:28 AM
Dimitar
 
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]
Dear Anonymous, I think the above is not supported by SQL 92.
Reply With Quote