Thread
:
How to find second highest value of a column in a table? | SQL?
View Single Post
#
5
(
permalink
)
08-31-2006, 06:28 AM
Dimitar
Posts: n/a
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.
Dimitar