blob: 62facaba87bfc239d7bfbda37f74b5c65cb3c264 [file] [log] [blame]
SELECT *
FROM
(select c4 from `t_alltype.parquet` ) t1,
(select c4 from `t_alltype.parquet` ) t2
WHERE t1.c4 = t2.c4 OR (t1.c4 IS NULL AND t2.c4 IS NULL)
ORDER BY t1.c4 NULLS LAST;