Thread: How to find second highest value of a column in a table?
View Single Post
  #25 (permalink)  
Old 05-20-2008, 03:25 AM
Unregistered
 
Posts: n/a
Default ANY answer. Re: How to find second highest value of a column in a table?
[sql]select max(column_value) from table where column_value<(select max(column_value) from table);[/sql]


from
Mateti Kranthi Kumar
Reply With Quote