Re: Top n Scores
NVM?
From your dataset ...
Fred 50
Fred 30
Fred 20
Fred 10
Fred 5
Barney 15
Barney 15
Barney 10
Barney 5
you said you wanted the result ...
Fred 50
Fred 30
Barney 15
Barney 15
which you can get very easily, as suggested, from a pre-query using DISTINCT. Now you say "dupes are significant. They can't/shouldn't be sorted out." Which is it?
And, if the table hasn't a PK, it's not a real table and all bets are off, so why not give it one?
PB
Subject
Written By
Posted
Re: Top n Scores
August 11, 2009 01:35PM
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.