SELECT * FROM Products
WHERE Price > ANY (SELECT Price FROM Products WHERE Price > 50);
ProductID | ProductName | SupplierID | CategoryID | QuantityPerUnit | Price | UnitsInStock | UnitsOnOrder | ReorderLevel | Discontinued |
---|---|---|---|---|---|---|---|---|---|
9 | Mishi Kobe Niku | 4 | 6 | 18 - 500 g pkgs. | 97.0000 | 29 | 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 |
29 | Thüringer Rostbratwurst | 12 | 6 | 50 bags x 30 sausgs. | 123.7900 | 0 | 0 | 0 | True |
38 | C?te de Blaye | 18 | 1 | 12 - 75 cl bottles | 263.5000 | 17 | 0 | 15 | False |
59 | Raclette Courdavault | 28 | 4 | 5 kg pkg. | 55.0000 | 79 | 0 | 0 | False |