Example: Proper form of temporal queries using set operations - Analytics Database - Teradata Vantage

The following query would yield an error:

VALIDTIME AS OF DATE '2009-05-06'
SELECT *
FROM v1

MINUS

VALIDTIME AS OF DATE '2009-05-05'
SELECT *
FROM v1

ORDER BY 1;

The following query would run properly to yield the desired results:

SELECT *
FROM v1 VALIDTIME AS OF DATE '2009-05-06'

MINUS

SELECT *
FROM v1 VALIDTIME AS OF DATE '2009-05-05'

ORDER BY 1;