应用于检测数据,sql代码如下:

脚本代码:

select from table_name1 minus select from table_name2

例子:

SELECT

ADDRESS_ID

,ADDRESS_NAME

,USER_ID

,CONSIGNEE

,EMAIL

,COUNTRY

,PROVINCE

,CITY

,DISTRICT

,ADDRESS

,ZIPCODE

,TEL

,MOBILE

,SIGN_BUILDING

,BEST_TIME

,COUNTRYSIDE

FROM KXNC_USER_ADDRESS

MINUS

SELECT

ADDRESS_ID

,ADDRESS_NAME

,USER_ID

,CONSIGNEE

,EMAIL

,COUNTRY

,PROVINCE

,CITY

,DISTRICT

,ADDRESS

,ZIPCODE

,TEL

,MOBILE

,SIGN_BUILDING

,BEST_TIME

,COUNTRYSIDE

FROM etl_USER_ADDRESS