我想查看一个对象在一周内的重复记录。我只关心看到重复的记录,而不是只有单个实例的对象。目前我的查询语句是:
SELECT a.asset, t.ticketnum, t.symptom_mask, t.setsolution, t.`otherdesc`
FROM lamarinfo AS a
JOIN lfso AS t
ON (a.id = t.asset_id)
WHERE open_dt BETWEEN CURDATE() - INTERVAL 7 DAY AND SYSDATE()
GROUP BY a.`asset` HAVING COUNT(*) > 1;
这会返回重复的记录,但不是每个重复记录的所有内容。有什么想法吗?