求按 每周的8:30到 本周最后一天的 8:30 统计语句
一周的计算 是按(周末到周六),
例如:2010-3-7 8:30 是此周的第一天,2010-3-14 8:30 之前
是此周的 最后一天
求怎么写SQL语句。
我之前的语句是没有 按8:30 这个时间间隔进行统计的。代码如下:
SET DATEFIRST 7 select a.flawNo,a.flawName,datename(week,checkTime) as weekNum,sum(isflaw) as youflaw from
testmes.dbo.qcc_flawinfo as info left join testmes.dbo.qcc_flawB as b on b.flawBNo=info.flawBNo left join testmes.dbo.qcc_flawa as a on a.flawNo=b.flawNo left join testmes.dbo.mes_category as ca on ca.categoryNo=a.categoryNo group by a.flawNo,a.flawName,datename(week,checkTime) order by a.flawNo,a.flawName,datename(week,checkTime)