max rows

max rows

 

  

Dear all,

Can I get two max rows in a query like:



Select max(col1)

From table1



Now if it returns 10 rows I want to get only 2 highest value rows.



Thanks,




Oracle LazyDBA home page