ALL
ALL 명령은 모든 하위 쿼리 값이 조건을 충족하는 경우 true를 반환한다.
예시
TRUE를 반환하고 OrderDetails 테이블의 모든 레코드 중 수량 = 10인 경우 제품 이름을 나열한다.
SELECT ProductName FROM Products WHERE ProductID = ALL (SELECT ProductID FROM OrderDetails WHERE Quantity = 10);
기본 예시
| ProductName |
|---|
| Chais |
| Chang |
| Aniseed Syrup |
| Chef Anton’s Cajun Seasoning |
| Chef Anton’s Gumbo Mix |
| Grandma’s Boysenberry Spread |
| Uncle Bob’s Organic Dried Pears |
| Northwoods Cranberry Sauce |
| Mishi Kobe Niku |
| Ikura |
| Queso Cabrales |
| Queso Manchego La Pastora |
| Konbu |
| Tofu |
| Genen Shouyu |
| Pavlova |
| Alice Mutton |
| Carnarvon Tigers |
| Teatime Chocolate Biscuits |
| Sir Rodney’s Marmalade |
| Sir Rodney’s Scones |
| Gustaf’s Knäckebröd |
| Tunnbröd |
| Guaraná Fantástica |
| NuNuCa Nuß-Nougat-Creme |
| Gumbär Gummibärchen |
| Schoggi Schokolade |
| Rössle Sauerkraut |
| Thüringer Rostbratwurst |
| Nord-Ost Matjeshering |
| Gorgonzola Telino |
| Mascarpone Fabioli |
| Geitost |
| Sasquatch Ale |
| Steeleye Stout |
| Inlagd Sill |
| Gravad lax |
| Côte de Blaye |
| Chartreuse verte |
| Boston Crab Meat |
| Jack’s New England Clam Chowder |
| Singaporean Hokkien Fried Mee |
| Ipoh Coffee |
| Gula Malacca |
| Røgede sild |
| Spegesild |
| Zaanse koeken |
| Chocolade |
| Maxilaku |
| Valkoinen suklaa |
| Manjimup Dried Apples |
| Filo Mix |
| Perth Pasties |
| Tourtière |
| Pâté chinois |
| Gnocchi di nonna Alice |
| Ravioli Angelo |
| Escargots de Bourgogne |
| Raclette Courdavault |
| Camembert Pierrot |
| Sirop d’érable |
| Tarte au sucre |
| Vegie-spread |
| Wimmers gute Semmelknödel |
| Louisiana Fiery Hot Pepper Sauce |
| Louisiana Hot Spiced Okra |
| Laughing Lumberjack Lager |
| Scottish Longbreads |
| Gudbrandsdalsost |
| Outback Lager |
| Fløtemysost |
| Mozzarella di Giovanni |
| Röd Kaviar |
| Longlife Tofu |
| Rhönbräu Klosterbier |
| Lakkalikööri |
| Original Frankfurter grüne Soße |
참고
W3C School - SQL Add Keywords
W3C School - SQL Tutorial
공부 목적 블로그