时序数据库 TimechoDB v2.0.3 发布 | 支持元数据导入导出脚本适配表模型等功能

greatest(value1, value2, ..., valueN)least(value1, value2, ..., valueN)

select * from table;+-----------------------------+------+--------+---------+------------+------------+|                         time|region|plant_id|device_id|temperature1|temperature2|+-----------------------------+------+--------+---------+------------+------------+|2024-11-28T08:00:00.000+08:00|  上海|    3001|      100|        85.0|        90.0||2024-11-26T13:37:00.000+08:00|  北京|    1001|      100|        90.0|        85.0||2024-11-29T00:00:00.000+08:00|  上海|    3001|      101|        85.0|        84.0||2024-11-27T00:00:00.000+08:00|  北京|    1001|      101|        85.0|        87.0|+-----------------------------+------+--------+---------+------------+------------+

-- 查询 table 中 temperature1 和 temperature2 的最大、最小记录SELECT GREATEST(temperature1,temperature2),LEAST(temperature1,temperature2) FROM table5;

+-----+-----+|_col0|_col1|+-----+-----+| 90.0| 85.0|| 90.0| 85.0|| 85.0| 84.0|| 87.0| 85.0|+-----+-----+Total line number = 4It costs 0.088s