下面这句是 :查询同一个用户在同一天的重复操作记录...

SELECT I_User, CONVERT(varchar(16), I_date, 112) AS Ttime, COUNT(*) AS SUM
FROM table
GROUP BY CONVERT(varchar(16), I_date, 112), I_User
HAVING COUNT(*) > 1

我想把他改成 查询同一个用户在同一周的重复操作记录...

小弟先谢谢各位啦!

SELECT I_User, CONVERT(varchar(16), I_date, 112) AS Ttime, COUNT(*) AS SUM
FROM table wher Ttime between 第一天 and 最后一天
GROUP BY CONVERT(varchar(16), I_date, 112), I_User
HAVING COUNT(*) > 1

SELECT I_User, DATEPART(wk,idate) AS Ttime, COUNT(*) AS SUM
FROM table
GROUP BY DATEPART(wk,idate), I_User