> Hello!
>
> Is there any standard SQL-statement, which produce
> resultset containing best plyers of the each team?
>
> player |team|points
> -------------------
> paul col 10
> peter col 12
> steve det 12
> sergei det 8
> jere dal 4
Sure:
select distinct on (team) player,team,points
from resultset
order by team asc, points desc
Regards,
Tomasz Myrta