数据库中的最后一个星期 [英] last date in database make a week

问题描述

我正在使用查询来显示每周数据.但是我想从数据库中日期的最新输入开始一周.如何做到这一点?

我的查询如下:

I am using a query for showing weekly data.but i want to start week from latest entry of date in database.how to do this??

my query is given below:

select count(MissedLogParam) as MissedLogParam,convert(varchar(12),DATEADD(wk, DATEDIFF(wk,9, Server_DateTime),10),106)
 as 'Server_DateTime'
 from DeviceAlarmLog where Server_DateTime>=DATEADD(dd,-7,Server_DateTime) and IsAbsent=1
 group by DATEADD(wk, DATEDIFF(wk,9, Server_DateTime),10)
 order by DATEADD(wk, DATEDIFF(wk, 9, Server_DateTime),10)
 select count(MissedLogParam)  as 'TotalAlarm' from DeviceAlarmLog
group by DATEADD(wk, DATEDIFF(wk, 9, Server_DateTime),10)
order by DATEADD(wk, DATEDIFF(wk, 9, Server_DateTime),10)

推荐答案

赞这个MAX(日期) ???

Like this MAX(date) ???

这篇关于数据库中的最后一个星期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！