Software

Ask something
Discussion Locked

Top 100 by category

0 helpful
2 replies

by endusermike

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

2 replies

by endusermike

thanks for the suggestion, can you expand on the sSQL portion? I'm trying to run this as a pass through query in Access and I'm not familiar with sSQL....

Thanks,
Mike

This discussion is closed to new replies.