满意答案
linsci1233
2013.08.23
采纳率:58% 等级:12
已帮助:8203人
上个月是什么意思:针对当前系统时间来说的,如果是这样则如下:
自定义函数:
CREATE FUNCTION dbo.FncDate (@datetime datetime)
RETURNS varchar(10) AS
BEGIN
declare @tmp varchar(10)
if (@datetime is null)
set @tmp= ''
else
set @tmp=cast(year(@datetime) as varchar(4))+'-'+cast(Month(@datetime) as varchar(2))+'-'+cast(day(@datetime) as varchar(2))
return @tmp
END
查询语句:
select max(t.test_value) test_value,t.test_time from
( select count(test_value) test_value,dbo.FncDate(test_time) test_time from test where datediff(m,test_time,getdate())=1 group by dbo.FncDate(test_time) ) t
00分享举报