实例 SQL 比较运算符大于 >

​x
 
SELECT * FROM ProductsWHERE Price > 30;​                            

ProductID	ProductName	SupplierID	CategoryID	QuantityPerUnit	Price	UnitsInStock	UnitsOnOrder	ReorderLevel	Discontinued
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
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
32	Mascarpone Fabioli	14	4	24 - 200 g pkgs.	32.0000	9	40	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
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
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
69	Gudbrandsdalsost	15	4	10 kg pkg.	36.0000	26	0	15	False
72	Mozzarella di Giovanni	14	4	24 - 200 g pkgs.	34.8000	14	0	0	False