草庐IT

AgentActivityLog

全部标签

mysql - 如果两行相等,如何对值求和?

这是我的查询SelectAgentActivityLog.StatusDateTime,AgentActivityLog.UserId,AgentActivityLog.StateDuration/60ASMinutes,AgentActivityLog.StatusKeyFROMUserWorkgroupsINNERJOINAgentActivityLogONUserWorkgroups.UserId=AgentActivityLog.UserIdWHEREAgentActivityLog.StatusDateTimeBetween'08/01/2013'AND'08/02/2013