获得徽章 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 )
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
赞了这篇文章
赞了这篇文章
赞了这篇文章
A16 仿生芯片拥有 160 亿个晶体管。
CPU 提升 40%,功耗降低 20%,续航明显提升。全新的 NPU 每秒可以计算 170 亿次;GPU 带宽提升 50%。
CPU 提升 40%,功耗降低 20%,续航明显提升。全新的 NPU 每秒可以计算 170 亿次;GPU 带宽提升 50%。
3
点赞