TDengine
TDengine copied to clipboard
客户端执行partition by 聚合函数报错
需求是获取每个测点的最新数据
SELECT time, value, point_id FROM ( SELECT time, value, point_id, ROW_NUMBER() OVER (PARTITION BY point_id ORDER BY time DESC) AS rn FROM model_vision.point ) t WHERE t.rn = 1; 但是报错了