I am looking to return the top 100 items ranked by sales units for all of our categories. I would like to do this in one sql statement, somehow using the rank function but my experience with sql is rather limited. Is there a way to handle this rather easily using a combination of functions within Oracle SQL?