linq VB.NET 取某个值最大的行

发布时间：2020-12-17 08:12:42 所属栏目：百科来源：网络整理

导读：1.先获得最大值的汇总数据 Dim tem1 = From k In lstCPMasterTemp _ Group k By code = k.CpCode Into g = Group,maxVersion = Max(k.Version) _ Select code,maxVersion 2.Join原数据 m_lstCPMaster = (From k In lstCPMasterTemp _ Join g In tem1 On g.co

1.先获得最大值的汇总数据

Dim tem1 = From k In lstCPMasterTemp _
Group k By code = k.CpCode Into g = Group,maxVersion = Max(k.Version) _

Select code,maxVersion

2.Join原数据
m_lstCPMaster = (From k In lstCPMasterTemp _
Join g In tem1 On g.code Equals k.CpCode And g.maxVersion Equals k.Version _

Select k).ToList

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!