c# – LINQ join和group
发布时间:2020-12-15 08:04:34 所属栏目:百科 来源:网络整理
导读:我是LINQ的新手,我正在尝试将此SQL查询转换为其LINQ等效项: select S.*from Singles Sjoin ( select max(SingleId) as SingleId from Single group by ArtistId) S2 on S2.SingleId = S.SingleIdorder by Released desc 该表如下所示: -----------| Single
我是LINQ的新手,我正在尝试将此SQL查询转换为其LINQ等效项:
select S.* from Singles S join ( select max(SingleId) as SingleId from Single group by ArtistId) S2 on S2.SingleId = S.SingleId order by Released desc 该表如下所示: ----------- | Singles | |-----------| | SingleID | | ArtistId | | Released | | Title | | ..... | ----------- 等等… SingleID ArtistID Released Title 1 1 2011-05-10 Title1 2 1 2011-05-10 Title2 3 2 2011-05-10 Title3 4 3 2011-05-10 Title4 5 4 2011-05-10 Title5 6 2 2011-05-10 Title6 7 3 2011-05-10 Title7 8 5 2011-05-10 Title8 9 6 2011-05-10 Title9 所以我想要获得最新的单曲,但每个艺术家只有一个.谁能帮助我? (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |