sql - 选择一周的记录

Question

我写了这个查询，给我当天的记录

SELECT EnquiryOwner,Count(uid) 
FROM EnquiryMaster 
WHERE orgid = '" + orgid + "' 
    AND (DAY(date) = DAY(GETDATE()) 
    AND MONTH(date) = MONTH(GETDATE()) 
    AND YEAR(date) = YEAR(GETDATE())) 
GROUP BY EnquiryOwner

我想选择本周的记录。如果我在星期二访问，我想要从前一个星期二到这个星期二的记录

Answer 1

You can use dateadd to determine the date of one week before.

例如喜欢

DAY(date)   = DATEADD(day,   -7, GETDATE()) AND    
MONTH(date) = DATEADD(month, -7, GETDATE()) AND
YEAR(date)  = DATEADD(year,  -7, GETDATE()) 

或

... WHERE date between DATEADD(DAY,-7,GETDATE()) and GETDATE()

另请参阅 date and time functions 的列表.