Re: Top n Scores
By dupes you mean ties? Simplest would be to make a view for distinct values, and run the top N query on that view. If performance with the View is bad, make it a mem table instead of a view and run the top N query on that. If all else fails, work the dupe filtering logic into the top N query.
PB
http://www.artfulsoftware.com
Subject
Written By
Posted
Re: Top n Scores
August 10, 2009 09:50AM
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.