View Single Post
  #18 (permalink)  
Old 12-05-2007, 12:16 PM
deepak garg deepak garg is offline
Junior Member
 
Join Date: Dec 2007
Posts: 6
deepak garg is on a distinguished road
Wink ANY answer. How can find the rows excluding the top 2 highest values

this is how you can simply do this

[sql]select col_name from table_name where col_name not in (select col_name from (select col_name from table_name where col_name is not NULL order by col_name desc)
where rownum<=2)order by col_name[/sql]
Reply With Quote