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]
|