Convert query that using “EXCEPT”.

Oracle:

SELECT 1 FROM tt INTERSECT
SELECT 2 FROM tt;

HiRDB:

(SELECT 1 FROM tt) EXCEPT (SELECT 1 FROM tt EXCEPT SELECT 2 FROM tt);