Thread: How to find second highest value of a column in a table?
View Single Post
  #2 (permalink)  
Old 08-01-2006, 01:35 AM
Sebastian Martens
 
Posts: n/a
Default MS SQL answer. Re: How to find second highest value of a column in a table?
[sql]
SELECT * FROM table
WHERE columnName =
( SELECT MAX(columnName) FROM table where columnname<(select max(columnname) from table))
[/sql]
Reply With Quote