实例 SQL 比较运算符等于 =

​x
 
SELECT * FROM ProductsWHERE Price = 18;​                            

ProductID	ProductName	SupplierID	CategoryID	QuantityPerUnit	Price	UnitsInStock	ReorderLevel	Discontinued
1	Chai	1	1	10 boxes x 20 bags	18.0000	39	10	False
35	Steeleye Stout	16	1	24 - 12 oz bottles	18.0000	20	15	False
39	Chartreuse verte	18	1	750 cc per bottle	18.0000	69	5	False
76	Lakkalik??ri	23	1	500 ml	18.0000	57	20	False