22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT *
FROM hj69
WHERE x1_t20_q00_TIMESTAMP BETWEEN ... AND ...
AND NOT EXITS (SELECT *
FROM hj69 t
WHERE -- 同一段10分钟
FLOOR(TIMESTAMPDIFF(MINUTE,...,t.x1_t20_q00_TIMESTAMP)/10) =
FLOOR(TIMESTAMPDIFF(MINUTE,...,hj69.x1_t20_q00_TIMESTAMP)/10)
AND -- 时段内最小
t.x1_t20_q00_TIMESTAMP < hj69.x1_t20_q00_TIMESTAMP
)
select timestampdiff(minute,"2017-02-17 13:32:32","2017-02-17 13:32:38");
select timestampdiff(minute,"2017-02-17 13:32:32","2017-02-17 13:33:08");
我记得在Mysql版回答过这个问题。10分钟换成%600 秒贴上来看看啥结果