一个很难的SQL问题,希望高手帮帮忙,小弟先谢谢各位啦!
下面这句是 :查询同一个用户在同一天的重复操作记录...
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, datepart(week,I_date) AS Ttime, COUNT(*) AS SUM
FROM table
GROUP BY datepart(week,I_date), I_User
HAVING COUNT(*) > 1
[解决办法]
右上方,管理
