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 Resultset: peter steve jere ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster