General discussion
February 25, 2004 at 11:19 AM
endusermike

Top 100 by category

by endusermike . Updated 22 years, 6 months ago

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?

This discussion is locked

All Comments