Re: Help with optimizing GROUP BY query
Posted by:
lasse
Date: June 12, 2006 10:54AM
Problem is that there are alot of rows which have quizId=1 :|
Any other ways to get X number of hiscores? What defines a hiscore is that its the 10 (or more) best scores, but each userId can only be on the list once.
I guess making a hiscore table that contain a userid, and that users maxscore is possible... but I would like to avoid that if possible?
Thanks
Lasse
Subject
Views
Written By
Posted
5066
June 12, 2006 07:16AM
2543
June 12, 2006 08:37AM
Re: Help with optimizing GROUP BY query
2445
June 12, 2006 10:54AM
2457
June 12, 2006 01:01PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.