34,590
社区成员
发帖
与我相关
我的任务
分享
select SUM([LinesAdded]+[LinesModified]) AS updatelines , DateYearString ,DateMonthOfYear from [Tfs_Warehouse].[dbo].[CodeChurnView] where FilenameFilePath like '"+path+"%' group by DateYearString,DateMonthOfYear order by DateYearString,DateMonthOfYear;"
select SUM([LinesAdded]+[LinesModified]) AS updatelines , -- 汇总求和所有([LinesAdded]+[LinesModified])
DateYearString ,DateMonthOfYear -- 字段列表
from [Tfs_Warehouse].[dbo].[CodeChurnView] -- 表名
where FilenameFilePath like '"+path+"%' -- 过滤条件
group by DateYearString,DateMonthOfYear -- 根据DateYearString,DateMonthOfYear汇总
order by DateYearString,DateMonthOfYear -- 根据DateYearString,DateMonthOfYear排序