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