Programming, Alibaba Cloud, Database, Postgresql, Data Analytics.
means that sensors that do not have a record within an hour are considered offline. The enterprise needs to count the minimum and maximum number of online sensors per minute. 1. Table Structure create table sensor_stat( sid int, -- 传感器ID state boolean, -- 传感器状态，true在线，false离线 crt_time timestamp --