151.View the Exhibit and examine the structure of the CUSTOMERS and CUST_HISTORY tables.

本博客展示了如何利用SQL的MINUS操作符来筛选出从未改变过地址的客户,通过比较当前客户表和历史客户变更记录表,实现精准的数据筛选。
151.View the Exhibit and examine the structure of the CUSTOMERS and CUST_HISTORY tables.
The CUSTOMERS table contains the current location of all currently active customers. The
CUST_HISTORY table stores historical details relating to any changes in the location of all current as well
as previous customers who are no longer active with the company.
You need to find those customers who have never changed their address.
Which SET operator would you use to get the required output?


A.MINUS
B.UNION
C.INTERSECT
D.UNION ALL
答案:A
解析:
MINUS:取差
UNION:取加,但是排除重复
INTERSECT:取交集
UNION ALL:取加,不排除重复
从题目中可以看出选A

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值