写在数据库的视图sql compute语句,可以有条件地求平均值吗? Post By:2014/8/11 18:37:00 [只看该作者]
各位老师好
我之前在项目里写这段代码:
For Each dr As DataRow In DataTables("每日销售").DataRows If dr("辅助列") > 6 Then dr("MA7") = DataTables("每日销售").Compute("Avg("销售额")"," 辅助列 >= " & dr("辅助列")-6 & " And 辅助列 <= " & dr("辅助列") & " ") End If Next
我想直接写在后台数据库里的视图来统计 MA7 这列的值
SELECT dbo.[每日销售].[日期], Compute("Avg("销售额")"," 辅助列 >= " & dr("辅助列")-6 & " And 辅助列 <= " & dr("辅助列") & ") 不知道这个条件要怎么写 FROM dbo.[每日销售] GROUP BY dbo.[每日销售].[日期], dbo.[每日销售].[销售额]