时序数据库TDengine窗口函数
select ts, lp_index,max(lp_value),lp_project_id, lp_variable_uri,lp_time_ticks, lp_value_type_value, lp_value, lp_unit from weixingdata.tdm_lp_original_datawherelp_time_ticks >= '2023-11-27 12:38:41'a
select ts, lp_index,
max(lp_value),
lp_project_id, lp_variable_uri,
lp_time_ticks, lp_value_type_value, lp_value, lp_unit from sifudata.tdm_lp_original_data
where lp_time_ticks >= '2023-11-27 12:38:41'
and lp_time_ticks <= '2023-11-27 14:38:41'
and lp_project_id = '0A66F139-F8BF-485A-9F3B-DECD40C3E6D9'
and lp_variable_uri = 'tr://Resource1/Group1/TP2253/P3'
INTERVAL(120s) SLIDING(30s)
order by lp_time_ticks asc
DAMO开发者矩阵，由阿里巴巴达摩院和中国互联网协会联合发起，致力于探讨最前沿的技术趋势与应用成果，搭建高质量的交流与分享平台，推动技术创新与产业应用链接，围绕“人工智能与新型计算”构建开放共享的开发者生态。
更多推荐
3
0- 0
已为社区贡献5条内容
所有评论(0)