i have a table which for ease of explanation consists of
user (3 letter code) - sale_id - date
there are probably 70 distinct users, each with maybe 100 sales
is there any way to return the top 10 sales, for each user, in one query
(it would be even more helpful if someone knows how to do the same thing in crystal enterprise)
user (3 letter code) - sale_id - date
there are probably 70 distinct users, each with maybe 100 sales
is there any way to return the top 10 sales, for each user, in one query
(it would be even more helpful if someone knows how to do the same thing in crystal enterprise)