|
SELECT coalesce(sum(CASE WHEN num1 = 0 AND num2 = 1 THEN 0 ELSE 1 END), 0)
FROM (
SELECT sum(CASE WHEN num1 = num2 THEN 0 ELSE 1 END) num1, count(1) num2
FROM (
SELECT DISTINCT num1, sum(num3) over(PARTITION BY num1) num2
FROM (
SELECT count(1) over() num1, rang() over(order by a.c1) num2, count(1) over(PARTITION BY a.c1) num3,a.* FROM t1 a
UNIOM
SELECT count(1) over() num1, rang() over(order by a.c1) num2, count(1) over(PARTITION BY a.c1) num3,a.* FROM t2 a
) t
) t
) t
若查询结果为0则表示表t1和表t2数据相同,若为1则表示表t1和表t2数据存在差异
注:c1为两个表的第一列 |
|