Skip to main content

Table 1 SQL queries for calculating the different levels of time aggregation

From: SensorDB: a virtual laboratory for the integration, visualization and analysis of varied biological sensor data

  1. Example of SQL queries used for calculating time aggregation in MySQL and PostgreSQL. This example shows the aggregation of 5 minutes over the 12 months table Irradiance_12m. Different levels of aggregation can be obtained by changing the value of the minutes used in the DIV operation