一个很难的SQL问题,查询同一周的相同操作

gaohanxiong 发布于 2007-07-11 17:44， 700 次点击

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

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

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

小弟先谢谢各位啦!

2 回复

foolsihbird2007-07-13 14:15

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

lzalibabalr2007-08-02 12:18

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