实例 SQL 逻辑运算符 ANY

​x
 
SELECT * FROM ProductsWHERE Price > ANY (SELECT Price FROM Products WHERE Price > 50);​                            

ProductID	ProductName	SupplierID	CategoryID	QuantityPerUnit	Price	UnitsInStock	ReorderLevel	Discontinued
9	Mishi Kobe Niku	4	6	18 - 500 g pkgs.	97.0000	29	0	True
18	Carnarvon Tigers	7	8	16 kg pkg.	62.5000	42	0	False
20	Sir Rodney's Marmalade	8	3	30 gift boxes	81.0000	40	0	False
29	Thüringer Rostbratwurst	12	6	50 bags x 30 sausgs.	123.7900	0	0	True
38	C?te de Blaye	18	1	12 - 75 cl bottles	263.5000	17	15	False
59	Raclette Courdavault	28	4	5 kg pkg.	55.0000	79	0	False