linq　副問い合わせとmax値の取得について SQLlinq SELECT id ,kaisu ,henkou ,furigana ,sex ,nengo ,birthday ,idno FROM tableA AS A, ( SELECT id as Bid ,MAX(kaisu) as Bkaisu FROM tableA as B GROUP BY Bid ) as B where A.id = B.Bid and A.kaisu = B.Bkaisu order by A.id

SELECT id as Bid
, MAX(kaisu) as Bkaisu
FROM tableA as B
GROUP BY Bid


`GroupBy``Select`


var b = tableA
.GroupBy(r => r.id)
.Select(g => new
{
Bid = g.Key,
BKaisu = g.Max(r => r.kaisu)
});


`b`