110,561
社区成员
发帖
与我相关
我的任务
分享
select Convert(varchar(7),uploadtime,120) as uploadtime,sum(uNum) as uNum from @t1
group by Convert(varchar(7),uploadtime,120)
select min(username) username,
cast(YEAR(uploadtime) as varchar(4))+'-'+cast(month(uploadtime) as varchar(2)) as [date],
sum(uNum) uNum from @t
where uploadtime>'2009-05-01' and uploadtime<'2009-10-01'
group by cast(YEAR(uploadtime) as varchar(4))+'-'+cast(month(uploadtime) as varchar(2))
declare @t1 table(username varchar(20),uploadtime datetime,uNum int)
insert into @t1 values('系统用户' ,'2009-06-29 08:16:18.907', 5 )
insert into @t1 values('系统用户' ,'2009-06-29 08:30:08.620', 3 )
insert into @t1 values('系统用户' ,'2009-06-30 12:00:55.917', 3 )
insert into @t1 values('系统用户' ,'2009-08-31 14:35:10.327', 1 )
insert into @t1 values('系统用户' ,'2009-09-02 10:00:16.787', 1 )
select LEFT(Convert(varchar(20),uploadtime,120),7) as uploadtime,sum(uNum) as uNum from @t1
group by LEFT(Convert(varchar(20),uploadtime,120),7)
select min(username) username,cast(YEAR(uploadtime) as varchar(4))+'-'+cast(month(uploadtime) as varchar(2)) as [date],sum(uNum) uNum from @t
where uploadtime>'2009-05-01' and uploadtime<'2009-10-01'
group by cast(YEAR(uploadtime) as varchar(4))+'-'+cast(month(uploadtime) as varchar(2))
declare @t1 table(username varchar(20),uploadtime varchar(20),uNum int)
insert into @t1 values('系统用户','2009-6',11)
insert into @t1 values('系统用户','2009-8',1)
insert into @t1 values('系统用户','2009-9',1)
select * from @t1
where Convert(int,REPLACE( uploadtime,'-','')) between
Convert(int,REPLACE( '2009-5','-','')) and
Convert(int,REPLACE( '2009-10','-',''))
declare @t table(username varchar(20),uploadtime datetime,uNum int)
insert into @t select '系统用户','2009-06-29 08:16:18.907',5
union all select '系统用户', '2009-06-29 08:30:08.620', 3
union all select '系统用户', '2009-06-30 12:00:55.917', 3
union all select '系统用户', '2009-08-31 14:35:10.327', 1
union all select '系统用户', '2009-09-02 10:00:16.787', 1
select * from @t
select min(username) username,cast(YEAR(uploadtime) as varchar(4))+'-'+cast(month(uploadtime) as varchar(2)) as [date],sum(uNum) uNum from @t
where uploadtime>'2009-05-01' and uploadtime<'2009-10-01'
group by cast(YEAR(uploadtime) as varchar(4))+'-'+cast(month(uploadtime) as varchar(2))