Thread
:
How to find second highest value of a column in a table? | SQL?
View Single Post
#
7
(
permalink
)
12-06-2006, 01:28 PM
Musclebai
Posts: n/a
SQL 92
answer.
Re: How to find second highest value of a column in a table? | SQL?
[sql]
SELECT max(score ) FROM scores WHERE score not in (SELECT max(score)
FROM scores)
[/sql]
Musclebai
SQL 92