sqlserver周次,sql 周

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

sqlserver怎么获得最后一周，最近一月的日期

1、最近一月比较简单，取当前时间的年份和月份，拼接成当前月份1号。

2、最后一周：取当前的时间为参考，用datepart取出时间的周编号，进行筛选，获取最近周1的日期，比如，表格a,日期字段rq

select max(rq) from 表格a

where datepart(weekday,rq) = 2 and rq 当前时间按到 rq 本月1号;

相关问答

Q1: sqlserver怎么按周来统计数据

指定一个起始日，计算到该日的天数，/7 得到经过的周数。然後按这个周数分组。

Q2: SQL统计双休日

select Inspect_name,

A=sum(A), B=sum(B),双休日=sum(case when 双休日 = 2 then 1 else 0 end)

from

(

select weekly,Inspect_name,

A=sum(A), B=sum(B),双休日=sum(case when 双休日119 then 1 else 0 end)

from

(

select weekly, Inspect_name, vdatetime2,

sum(case when rank= 'A' then 1 else 0 end) A,

sum(case when rank= 'B' then 1 else 0 end) B,

SUM(CASE WHEN xxx = '休' THEN vtime ELSE 0 END) AS 双休日

from

(

select datepart(wk,(case when convert(varchar(16),vdatetime2,120) between convert(varchar(10),vdatetime2,120)+' 00:00' and convert(varchar(10),vdatetime2,120)+' 05:01' then vdatetime2 -1

else vdatetime2 end)) as weekly,Inspect_name, rank,

(case when convert(varchar(16),vdatetime2,120) between convert(varchar(10),vdatetime2,120)+' 00:00' and convert(varchar(10),vdatetime2,120)+' 05:01' then convert(varchar(10),vdatetime2 -1,120)

else convert(varchar(10),vdatetime2,120) end) as vdatetime2,

( CASE WHEN(datepart(dw, vdatetime2)=6 AND CONVERT(VARCHAR(8),vdatetime2,108)'23:00') OR (datepart(dw, vdatetime2)=7 )or (datepart(dw, vdatetime2)=1 ) OR(datepart(dw, vdatetime2)=2 AND CONVERT(VARCHAR(8),vdatetime2,108) '04:59')THEN '休' ELSE '不休' END) as 'xxx',

vtime

from tb

) t

group by weekly,Inspect_name, vdatetime2

) Tbl

group by weekly,Inspect_name

) tbl1

group by Inspect_name

DATEPART(ww,DATE) 函数计算的周次讲解：

这个函数是以周日为每个周次的第一天，所以你要实现周一为每周的开始必须这样书写才能实现

DATEPART(ww,DATE-1)

Q3: sqlserver语句，按周分组统计数据，请各位大神指教小弟。