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
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
