获取customers中缺失电话号码的顾客
/*获取customers中缺失电话号码的顾客*/
SELECT *
FROM customers
WHERE phone IS NULL
IS NOT NULL
/*使用NOT运算符得到有号码的顾客*/
SELECT *
FROM customers
WHERE phone IS NOT NULL
获取customers中缺失电话号码的顾客
/*获取customers中缺失电话号码的顾客*/
SELECT *
FROM customers
WHERE phone IS NULL
IS NOT NULL
/*使用NOT运算符得到有号码的顾客*/
SELECT *
FROM customers
WHERE phone IS NOT NULL