通过基于分钟跳过记录从表中获取数据

更新时间：2023-02-26 10:16:02

SELECT id, pos_datetime
FROM mytable 
WHERE id IN (
SELECT MIN(id)
FROM mytable 
GROUP BY 
ROUND(UNIX_TIMESTAMP(pos_datetime)/(1 * 60)))

技术问答最新文章