选择 City
列的值不以字母“a”开头的所有记录。
SELECT * FROM Customers
@(24);
SELECT * FROM Customers
WHERE City NOT LIKE 'a%';
SELECT * FROM Customers
WHERE City NOT LIKE "a%";
SELECT * FROM Customers
WHERE NOT City LIKE 'a%';
SELECT * FROM Customers
WHERE NOT City LIKE "a%";