Question

我与Netezzakou合作。

附录一有两个表格:

### TABLE1

  var1 var2
1    1    a
2    1    b
3    1    c

## TABLE2

  var1 var2
1    1    a
2    1    b
3    1    c

如果我使用区域方案拟订语言,我可以轻易核实这两个表格是相同的:

> identical(table1, table2)
[1] TRUE

My Question: Is it possible to do something similar in Netezza SQL?

感谢!

Answer 1

Set营运人可用于发现两个表之间的差异。

EXCEPT ALL >,从第一个结果设定的第二次结果中删除了相同的字句,这必须按两种顺序进行,以便产生所有差异。 http://www.un.org/Depts/DGACM/index_french.htm。如果退款,则行数不变。 <条形>COUNT 传真 = 0 <0> / 编号>将作为“风气”返回。

-- Example data and table names with a CTE, this isn t required.
WITH TABLE1 (var1, var2) AS (
    VALUES (1,  a ), (1, b ), (1, c )
),
TABLE2 (var1, var2) AS (
    VALUES (1,  a ), (1, b ), (1, c )
)

-- Compare these tables
SELECT COUNT(*) = 0 AS IS_IDENTICAL FROM
(
    (
        SELECT * FROM TABLE1
        EXCEPT ALL
        SELECT * FROM TABLE2 
    )
    UNION ALL
    (
        SELECT * FROM TABLE2
        EXCEPT ALL
        SELECT * FROM TABLE1 
    )
)
;

产出:

IS_IDENTICAL
true

友情链接