ANY answer.
Re: How to find second highest value of a column in a table?
You can use following query to find any highest from a table column values:
[sql]SELECT MIN(columnName)
FROM tableName WHERE
columnName IN (SELECT DISTINCT TOP N columnName FROM tableName ORDER BY columnName DESC);[/sql]
|