SQL Sever里,有一张表,每天一条数据,请问在视图中如何按月统计某字段...答:create view viewname as select t1.* from (select convert(varchar,datepart(year,日期))+'-'+ convert(varchar,datepart(month,日期)) as 日期 ,count(*) as 个数 from tablename where 成绩>20 group by convert(varchar,datepart(year,日期))+'-'+ convert(varchar,datepart(month,...