SELECT Max(Id) as Id,ProductID,count(ProductID) as CountNumber
FROM QB_ProductRecord WHERE DATEDIFF(day, AddTM, GETDATE()) <15
GROUP BY ProductID
1.1.1
宝贝收藏榜
以14天为周期
的sql统计
DATEDIFF(day, AddTM, GETDATE()) <15
GROUP BY ProductID