通过选择最早的日期时间进行MySQL连接
通过选择最早的日期时间进行MySQL连接
提问于 2014-12-04 22:24:25
此查询根据票证分配给谁对票证进行分组，并计算出票证关闭所需的平均四舍五入天数。
SELECT a.id as theuser, round(avg(DATEDIFF( ta.dateClosed, t.dateAded ) * 1.0), 2) as avg
FROM tickets t join
mdl_user a
on find_in_set(a.id, t.assignedto) > 0
GROUP BY a.id ORDER BY avg ASC现在，我想加入ticketanswer表，以了解首次响应的平均时间。这张票可能有多个答案，所以我只想得到第一个答案。因此，我尝试将查询更改为包含此查询，但没有成功。有人能指出我做错了什么吗？
SELECT a.id as theuser, round(avg(DATEDIFF( ta.dateAded , t.dateAded ) * 1.0), 2) as avg
FROM tickets t join
mdl_user a
on find_in_set(a.id, t.assignedto) > 0
INNER JOIN (SELECT MIN(ta.dateAded) as started FROM ticketanswer GROUP BY ta.ticketId) ta ON t.id = ta.ticketId
GROUP BY a.id ORDER BY avg ASCStack Overflow用户
发布于 2014-12-04 22:35:46
对您的查询做了一些细微的修改。
SELECT a.id as theuser, round(avg(DATEDIFF( ta.dateAded , t.dateAded ) * 1.0), 2) as avg
FROM tickets t join
mdl_user a
on find_in_set(a.id, t.assignedto) > 0
INNER JOIN (SELECT ticketid, MIN(dateAded) as started FROM ticketanswer GROUP BY ticketId) ta ON t.id = ta.ticketId
GROUP BY a.id ORDER BY avg ASC页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/27296432
复制相关文章
相似问题
腾讯云开发者
