Sql查询以获取特定几周内客户的详细信息 [英] Sql query to fetch the details of customers across specific days of weeks

问题描述

大家好

需要帮助，包括sql查询，以检索一周中任何五天活跃的客户的详细信息： -



场景描述： -

Hi All
Needed help involving a sql query to retrieve the details of those customers who are active across any five days of the week:-

Scenario description:-

CustName	     Frequency  PurchaseDate	  Weekday


Mrs.Graciela 	        1	8/12/2016	Friday
Mrs.Kiley Cald	        1	8/12/2016	Friday
Ms.DonetteFold	        1	8/12/2016	Friday
Ms.Maya Kumar	        2       8/12/2016	Friday
Mr.Sage Wieser	        1	8/22/2016	Monday
Mr.Yuki Whobrey	        1       8/22/2016	Monday
Mr.Yuki Whobrey	        1	8/23/2016	Tuesday
Mr.Yuki Whobrey	        1	8/24/2016	Wednesday
Mr.Yuki Whobrey	        1	8/25/2016	Thursday
Mr.Yuki Whobrey	        1	8/26/2016	Friday

需要显示（例如）： -

Need to display(for e.g):-

All the "Mr.Yuki Whobrey" details since he was active during the five days in the week.

我尝试过：

What I have tried:

select CustName,Count(CustName),PurchaseDate,DATENAME(dw,PurchaseDate) 
 from [CustmrSrc] where DATENAME(dw,PurchaseDate) in ('Monday','Tuesday', 'Wednesday','Thursday','Friday') 
 Group By CustName, PurchaseDate

但是这个查询似乎不足以获取相关记录:(

请求帮助。

问候

However this query seems insufficient to fetch the relevant records:(
Requesting help on this.
Regards

推荐答案

尝试：

Try:

SELECT * FROM MYTable a
JOIN (SELECT CustName FROM MYTable
      GROUP BY CUSTName, DATEPART(ISO_WEEK,PurchaseDate)
      HAVING COUNT(PurchaseDate) >= 5) b
ON a.CustName = b.CustName

这篇关于Sql查询以获取特定几周内客户的详细信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！