Example: Using a sequenced aggregation with GROUP BY - Advanced SQL Engine - Teradata Database

Sequenced aggregations together with GROUP BY in the query includes "empty" valid-time periods during which none of the temporal table rows is valid. Assume the temporal table from the example above included another row for which the valid-time period was not contiguous with any of the existing valid time periods.

The query above would have returned two additional rows, one for the new duration, and one for the period that included no aircraft maintenance work:

This allows you to answer questions such as "During the time covered by the table, when were no aircraft undergoing service?"

SEQUENCED VALIDTIME PERIOD(date'2011-01-01', date'2012-03-01')
SELECT id FROM aircraft_service
       HAVING COUNT(ChargePerDay)= 0
       GROUP BY 1
       ORDER BY 1;

To prevent the "empty" valid-time period from being returned, add a condition to the query using the HAVING clause to filter out these rows.