实例 SQL 逻辑运算符 SOME

​x
 
SELECT * FROM ProductsWHERE Price > SOME (SELECT Price FROM Products WHERE Price > 20);​                            

输出结果

ProductID	ProductName	SupplierID	CategoryID	QuantityPerUnit	Price	UnitsInStock	UnitsOnOrder	ReorderLevel	Discontinued
4	Chef Anton's Cajun Seasoning	2	2	48 - 6 oz jars	22.0000	53	0	0	False
5	Chef Anton's Gumbo Mix	2	2	36 boxes	21.3500	0	0	0	True
6	Grandma's Boysenberry Spread	3	2	12 - 8 oz jars	25.0000	120	0	25	False
7	Uncle Bob's Organic Dried Pears	3	7	12 - 1 lb pkgs.	30.0000	15	0	10	False
8	Northwoods Cranberry Sauce	3	2	12 - 12 oz jars	40.0000	6	0	0	False
9	Mishi Kobe Niku	4	6	18 - 500 g pkgs.	97.0000	29	0	0	True
10	Ikura	4	8	12 - 200 ml jars	31.0000	31	0	0	False
12	Queso Manchego La Pastora	5	4	10 - 500 g pkgs.	38.0000	86	0	0	False
14	Tofu	6	7	40 - 100 g pkgs.	23.2500	35	0	0	False
17	Alice Mutton	7	6	20 - 1 kg tins	39.0000	0	0	0	True
18	Carnarvon Tigers	7	8	16 kg pkg.	62.5000	42	0	0	False
20	Sir Rodney's Marmalade	8	3	30 gift boxes	81.0000	40	0	0	False
26	Gumb?r Gummib?rchen	11	3	100 - 250 g bags	31.2300	15	0	0	False
27	Schoggi Schokolade	11	3	100 - 100 g pieces	43.9000	49	0	30	False
28	R?ssle Sauerkraut	12	7	25 - 825 g cans	45.6000	26	0	0	True
29	Thüringer Rostbratwurst	12	6	50 bags x 30 sausgs.	123.7900	0	0	0	True
30	Nord-Ost Matjeshering	13	8	10 - 200 g glasses	25.8900	10	0	15	False
32	Mascarpone Fabioli	14	4	24 - 200 g pkgs.	32.0000	9	40	25	False
37	Gravad lax	17	8	12 - 500 g pkgs.	26.0000	11	50	25	False
38	C?te de Blaye	18	1	12 - 75 cl bottles	263.5000	17	0	15	False
43	Ipoh Coffee	20	1	16 - 500 g tins	46.0000	17	10	25	False
51	Manjimup Dried Apples	24	7	50 - 300 g pkgs.	53.0000	20	0	10	False
53	Perth Pasties	24	6	48 pieces	32.8000	0	0	0	True
55	Paté chinois	25	6	24 boxes x 2 pies	24.0000	115	0	20	False
56	Gnocchi di nonna Alice	26	5	24 - 250 g pkgs.	38.0000	21	10	30	False
59	Raclette Courdavault	28	4	5 kg pkg.	55.0000	79	0	0	False
60	Camembert Pierrot	28	4	15 - 300 g rounds	34.0000	19	0	0	False
61	Sirop d'érable	29	2	24 - 500 ml bottles	28.5000	113	0	25	False
62	Tarte au sucre	29	3	48 pies	49.3000	17	0	0	False
63	Vegie-spread	7	2	15 - 625 g jars	43.9000	24	0	5	False
64	Wimmers gute Semmelkn?del	12	5	20 bags x 4 pieces	33.2500	22	80	30	False
65	Louisiana Fiery Hot Pepper Sauce	2	2	32 - 8 oz bottles	21.0500	76	0	0	False
69	Gudbrandsdalsost	15	4	10 kg pkg.	36.0000	26	0	15	False
71	Flotemysost	15	4	10 - 500 g pkgs.	21.5000	26	0	0	False
72	Mozzarella di Giovanni	14	4	24 - 200 g pkgs.	34.8000	14	0	0	False

参考手册

实例 SQL 逻辑运算符 SOME

输出结果