|
|
Posted by strawberry on 10/03/45 11:51
I'm not sure what happens when there's a tie between members of the
same family!
Roland Zitzke wrote:
> "strawberry" <zac.carey@gmail.com> schrieb
>
> > select lastname,sum(score) from (
> > select p1.lastname
> > , p1.firstname
> > , p1.score
> > from people as p1
> > inner
> > join people as p2
> > on p1.lastname = p2.lastname
> > and p1.score <= p2.score
> > group
> > by p1.lastname
> > , p1.score
> > having count(*) <= 3
> > order
> > by p1.lastname
> > , p1.score desc) xxx
> > group by lastname order by score desc;
>
> Yes, this is exactly what I needed - surely a brain twister.
> It might be worth puting a construct like this in some SQL FAQ as many
> people probably need to solve simmilar problems of selective ranking.
>
> Thanks
> /Roland
Navigation:
[Reply to this message]
|