Thread: How to find second highest value of a column in a table?
View Single Post
  #4 (permalink)  
Old 08-05-2006, 03:47 AM
sridhar.barla
 
Posts: n/a
Default Oracle answer. Re: How to find second highest value of a column in a table?
[sql]
SELECT quantity FROM Trade WHERE quantity=(SELECT MAX(quantity)
FROM Trade WHERE quantity<> (SELECT MAX(quantity) FROM Trade))
[/sql]
Edit/Delete Message Reply With Quote