SELECT
    *
FROM
    as_table([])
INTERSECT DISTINCT
SELECT
    *
FROM
    as_table([])
;

SELECT
    *
FROM
    as_table([])
INTERSECT DISTINCT
SELECT
    1 AS x,
    2 AS y
;

SELECT
    1 AS x,
    2 AS y
INTERSECT DISTINCT
SELECT
    *
FROM
    as_table([])
;