Linq - 每个组的最高值

7 浏览
0 Comments

Linq - 每个组的最高值

如何使用 Linq 在每个组中选择最高值？

当我有以下代码段时：

var teams = new Team[]
{
    new Team{PlayerName="Ricky",TeamName="Australia", PlayerScore=234},
    new Team{PlayerName="Hussy",TeamName="Australia", PlayerScore=134},
    new Team{PlayerName="Clark",TeamName="Australia", PlayerScore=334},
    new Team{PlayerName="Sankakara",TeamName="SriLanka", PlayerScore=34},
    new Team{PlayerName="Udana",TeamName="SriLanka", PlayerScore=56},
    new Team{PlayerName="Jayasurya",TeamName="SriLanka", PlayerScore=433},
    new Team{PlayerName="Flintop",TeamName="England", PlayerScore=111},
    new Team{PlayerName="Hamirson",TeamName="England", PlayerScore=13},
    new Team{PlayerName="Colingwood",TeamName="England", PlayerScore=421}
};

期望结果：

球队名称         球员名称     得分
斯里兰卡        杰伊苏里亚        433
英格兰           科林伍德         421
澳大利亚         克拉克            334

0