SELECT PERIOD DISTINCT
Created by: Piiit
Syntax:
SELECT PERIOD DISTINCT WITH (ts, te) a1,...,an
FROM E1,...,En
WHERE W
GROUP BY a1,...,an
Rewrite:
WITH X AS
(
SELECT *
FROM E1,...,En
WHERE W
)
SELECT DISTINCT a1,...,an
FROM
(
X NORMALIZE X X2 USING(a1,...,an) WITH (ts,te,ts,te)
) X
GROUP BY a1,...,an