SELECT $TD_TIMECODE_RANGE, $TD_GROUP_BY_TIME, BUOYID, AVG(TEMPERATURE) FROM OCEAN_BUOYS WHERE TD_TIMECODE BETWEEN TIMESTAMP '2014-01-06 08:00:00' AND TIMESTAMP '2014-01-06 10:00:00' GROUP BY TIME(MINUTES(30) AND BUOYID);
結果:
| TIMECODE_RANGE | GROUP BY TIME (MINUTES(30)) | BUOYID | AVG (TEMPERATURE) |
|---|---|---|---|
| ('2014-01-06 09:00:00.000000+00:00', '2014-01-06 09:30:00.000000+00:00') | 3 | 1 | 74 |
| ('2014-01-06 08:00:00.000000+00:00', '2014-01-06 08:30:00.000000+00:00') | 1 | 0 | 55 |