将SQL转换为LINQ:滚动平均
将SQL转换为LINQ:滚动平均
提问于 2011-04-25 00:07:12
我正在尝试为这个滚动平均SQL语句编写等价的LINQ，但我正在努力解决如何使用两次别名为x和y的同一个表(BulbSales)。
你能帮上忙吗？
SELECT x.Id, AVG(y.Sales) moving_average
FROM BulbSales x, BulbSales y
WHERE x.Id>=6 AND x.Id BETWEEN y.Id AND y.Id+5
GROUP BY x.Id
ORDER BY x.Id回答 1
Stack Overflow用户
回答已采纳
发布于 2011-04-25 00:21:54
如果这是LINQ to SQL，您可以尝试：
var query = from x in context.BulbSales
from y in context.BulbSales
where x.Id >= 6 && x.Id >= y.Id && x.Id <= (y.Id + 5)
group new { x.Id, y.Sales } by x.Id into g
orderby g.Key
select new { Id = g.Key, Average = g.Average(tuple => tuple.Sales) };这将生成SQL：
SELECT [t2].[Id], [t2].[value] AS [Average]
FROM (
SELECT AVG([t1].[Sales]) AS [value], [t0].[Id]
FROM [dbo].[BulbSales] AS [t0], [dbo].[BulbSales] AS [t1]
WHERE ([t0].[Id] >= @p0) AND ([t0].[Id] >= [t1].[Id]) AND ([t0].[Id] <= ([t1].[Id] + @p1))
GROUP BY [t0].[Id]
) AS [t2]
ORDER BY [t2].[Id]页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/5771619
复制相关文章
相似问题
腾讯云开发者
