lambda表达式根据UserID分组后获取最大的创建时间
1、查询语句如下
SELECT UserID,MAX(CreatedTime) CreatedTime
FROM T_UserHistory
WHERE UserID IN ('123456')
GROUP BY UserID
2、转lambda后
var userIDs = new[] {'123456'};
var result = UserHis
.Where(u=> userIDs.Contains(u.UserID))
.GroupBy(x => x.UserID)
.S
原创
2021-09-06 17:00:21 ·
1174 阅读 ·
0 评论