如何使用aggregation T-SQL获取日期？
如何使用aggregation T-SQL获取日期？
提问于 2012-11-09 23:46:14
我正在尝试获取客户的访问总次数，并获取上次访问日期和nextVisited
SELECT
COUNT( VisitTracking.customerID) AS #VISIT,
Customers.title,
Customers.firstName,
Customers.LastName,
Company.companyName,
VisitTracking.DateVisited,
CONVERT(date,VisitTracking.nextVisit)AS nextVisit
FROM VisitTracking
INNER JOIN Customers ON VisitTracking.customerID = Customers.customerID
INNER JOIN Customer_Company ON Customers.customerID = Customer_Company.customerID
INNER JOIN Company ON Customer_Company.companyID = Company.companyID
GROUP BY
Customers.title,
Customers.firstName,
Customers.LastName,
Company.companyName,
VisitTracking.DateVisited,
VisitTracking.nextVisit结果
#VISIT, title, firstName ,LastName, companyName, DateVisited, nextVisit
1, Mr, Tom, Tom, Jedii design, 2012-11-09, 2012-11-14
2 , Mr, Sam, Tom, compudata, 2012-11-10, 2012-11-14
1, Mr, Mike, Mike, compudata, 2012-11-10, 2012-11-14
1, Mr, Mike, Mike, compudata, 2012-11-16 ,2012-11-23
1, Mr, Ryan, Ryan, compudata, 2012-11-07 ,2012-11-09回答 1
Stack Overflow用户
回答已采纳
发布于 2012-11-10 01:12:07
SELECT
COUNT( VisitTracking.customerID) AS #VISIT,
Customers.title,
Customers.firstName,
Customers.LastName,
Company.companyName,
max(VisitTracking.DateVisited) as lastVisit,
max(CONVERT(date,VisitTracking.nextVisit)) AS nextVisit
FROM VisitTracking
INNER JOIN Customers ON VisitTracking.customerID = Customers.customerID
INNER JOIN Customer_Company ON Customers.customerID = Customer_Company.customerID
INNER JOIN Company ON Customer_Company.companyID = Company.companyID
GROUP BY
Customers.title,
Customers.firstName,
Customers.LastName,
Company.companyName页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/13311243
复制相关文章
相似问题
腾讯云开发者
Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有
深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 
粤公网安备44030502008569号
腾讯云计算（北京）有限责任公司 京ICP证150476号 | 京ICP备11018762号