实例 SQL 逻辑运算符 AND

​x
 
SELECT * FROM CustomersWHERE City = 'London' AND Country = 'UK';​                            

CustomerID	CustomerName	ContactName	ContactTitle	Address	City	PostalCode	Country	Phone	Fax
AROUT	Around the Horn	Thomas Hardy	Sales Representative	120 Hanover Sq.	London	WA1 1DP	UK	(171) 555-7788	(171) 555-6750
BSBEV	B's Beverages	Victoria Ashworth	Sales Representative	Fauntleroy Circus	London	EC2 5NT	UK	(171) 555-1212
CONSH	Consolidated Holdings	Elizabeth Brown	Sales Representative	Berkeley Gardens 12 Brewery	London	WX1 6LT	UK	(171) 555-2282	(171) 555-9199
EASTC	Eastern Connection	Ann Devon	Sales Agent	35 King George	London	WX3 6FW	UK	(171) 555-0297	(171) 555-3373
NORTS	North/South	Simon Crowther	Sales Associate	South House 300 Queensbridge	London	SW7 1RZ	UK	(171) 555-7733	(171) 555-2530
SEVES	Seven Seas Imports	Hari Kumar	Sales Manager	90 Wadhurst Rd.	London	OX15 4NB	UK	(171) 555-1717	(171) 555-5646