求语句怎么写 返回
SqlSugar
老数据
1
2323
爱的代价 发布于2018/5/4
悬赏：5 飞吻
SELECT
j.guest,
j.goods,
j.yanse,
SUM ( j.pishu ) pishu,
j.ysman
FROM
rk j
GROUP BY
j.guest ,
j.goods ,
j.yanse,
j.ysman
热忱回答（1）
-
爱的代价 VIP0
2018/5/4
var rk = db.Queryable<rk>() .GroupBy(x => new { x.goods, x.yanse, x.pishu, x.ysman }) .Select(x => new { x.goods, x.yanse, mishu = SqlFunc.AggregateSum(x.pishu), x.ysman }).ToList();已经知道怎么写
0 回复