juejin.cn
获得徽章 16
- 查询同一列的相同ID的时间间隔
SELECT t1.process_id,
t1.log_date,
COALESCE(TIMESTAMPDIFF(SECOND, t2.log_date, t1.log_date), 0) time_diff
FROM gyc_process_log t1
LEFT JOIN gyc_process_log t2 ON t1.process_id = t2.process_id
AND t1.log_date > t2.log_date
WHERE NOT EXISTS ( SELECT NULL
FROM gyc_process_log t3
WHERE t1.process_id = t3.process_id
AND t1.log_date > t3.log_date
AND t3.log_date > t2.log_date )展开赞过
评论1
