本文介绍了Sql查询以获取特定几周内客户的详细信息的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好
需要帮助,包括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
推荐答案
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查询以获取特定几周内客户的详细信息的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!