Example: Using a sequenced aggregation with GROUP BY - Analytics Database - Teradata Vantage

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 preceding example included another row for which the valid-time period was not contiguous with any of the existing valid time periods.

The preceding query 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.