IS NOT NULL
IS NOT NULL 명령은 비어 있지 않은 값을 테스트하는 데 사용된다.
예제
“주소” 필드에 값이 있는 모든 고객을 나열한다.
SELECT CustomerName, ContactName, Address FROM Customers WHERE Address IS NOT NULL;
기본 예시
| CustomerName | ContactName | Address |
|---|---|---|
| Alfreds Futterkiste | Maria Anders | Obere Str. 57 |
| Ana Trujillo Emparedados y helados | Ana Trujillo | Avda. de la Constitución 2222 |
| Antonio Moreno Taquería | Antonio Moreno | Mataderos 2312 |
| Around the Horn | Thomas Hardy | 120 Hanover Sq. |
| Berglunds snabbköp | Christina Berglund | Berguvsvägen 8 |
| Blauer See Delikatessen | Hanna Moos | Forsterstr. 57 |
| Blondel père et fils | Frédérique Citeaux | 24, place Kléber |
| Bólido Comidas preparadas | Martín Sommer | C/ Araquil, 67 |
| Bon app’ | Laurence Lebihans | 12, rue des Bouchers |
| Bottom-Dollar Marketse | Elizabeth Lincoln | 23 Tsawassen Blvd. |
| B’s Beverages | Victoria Ashworth | Fauntleroy Circus |
| Cactus Comidas para llevar | Patricio Simpson | Cerrito 333 |
| Centro comercial Moctezuma | Francisco Chang | Sierras de Granada 9993 |
| Chop-suey Chinese | Yang Wang | Hauptstr. 29 |
| Comércio Mineiro | Pedro Afonso | Av. dos Lusíadas, 23 |
| Consolidated Holdings | Elizabeth Brown | Berkeley Gardens 12 Brewery |
| Drachenblut Delikatessend | Sven Ottlieb | Walserweg 21 |
| Du monde entier | Janine Labrune | 67, rue des Cinquante Otages |
| Eastern Connection | Ann Devon | 35 King George |
| Ernst Handel | Roland Mendel | Kirchgasse 6 |
| Familia Arquibaldo | Aria Cruz | Rua Orós, 92 |
| FISSA Fabrica Inter. Salchichas S.A. | Diego Roel | C/ Moralzarzal, 86 |
| Folies gourmandes | Martine Rancé | 184, chaussée de Tournai |
| Folk och fä HB | Maria Larsson | Åkergatan 24 |
| Frankenversand | Peter Franken | Berliner Platz 43 |
| France restauration | Carine Schmitt | 54, rue Royale |
| Franchi S.p.A. | Paolo Accorti | Via Monte Bianco 34 |
| Furia Bacalhau e Frutos do Mar | Lino Rodriguez | Jardim das rosas n. 32 |
| Galería del gastrónomo | Eduardo Saavedra | Rambla de Cataluña, 23 |
| Godos Cocina Típica | José Pedro Freyre | C/ Romero, 33 |
| Gourmet Lanchonetes | André Fonseca | Av. Brasil, 442 |
| Great Lakes Food Market | Howard Snyder | 2732 Baker Blvd. |
| GROSELLA-Restaurante | Manuel Pereira | 5ª Ave. Los Palos Grandes |
| Hanari Carnes | Mario Pontes | Rua do Paço, 67 |
| HILARIÓN-Abastos | Carlos Hernández | Carrera 22 con Ave. Carlos Soublette #8-35 |
| Hungry Coyote Import Store | Yoshi Latimer | City Center Plaza 516 Main St. |
| Hungry Owl All-Night Grocers | Patricia McKenna | 8 Johnstown Road |
| Island Trading | Helen Bennett | Garden House Crowther Way |
| Königlich Essen | Philip Cramer | Maubelstr. 90 |
| La corne d’abondance | Daniel Tonini | 67, avenue de l’Europe |
| La maison d’Asie | Annette Roulet | 1 rue Alsace-Lorraine |
| Laughing Bacchus Wine Cellars | Yoshi Tannamuri | 1900 Oak St. |
| Lazy K Kountry Store | John Steel | 12 Orchestra Terrace |
| Lehmanns Marktstand | Renate Messner | Magazinweg 7 |
| Let’s Stop N Shop | Jaime Yorres | 87 Polk St. Suite 5 |
| LILA-Supermercado | Carlos González | Carrera 52 con Ave. Bolívar #65-98 Llano Largo |
| LINO-Delicateses | Felipe Izquierdo | Ave. 5 de Mayo Porlamar |
| Lonesome Pine Restaurant | Fran Wilson | 89 Chiaroscuro Rd. |
| Magazzini Alimentari Riuniti | Giovanni Rovelli | Via Ludovico il Moro 22 |
| Maison Dewey | Catherine Dewey | Rue Joseph-Bens 532 |
| Mère Paillarde | Jean Fresnière | 43 rue St. Laurent |
| Morgenstern Gesundkost | Alexander Feuer | Heerstr. 22 |
| North/South | Simon Crowther | South House 300 Queensbridge |
| Océano Atlántico Ltda. | Yvonne Moncada | Ing. Gustavo Moncada 8585 Piso 20-A |
| Old World Delicatessen | Rene Phillips | 2743 Bering St. |
| Ottilies Käseladen | Henriette Pfalzheim | Mehrheimerstr. 369 |
| Paris spécialités | Marie Bertrand | 265, boulevard Charonne |
| Pericles Comidas clásicas | Guillermo Fernández | Calle Dr. Jorge Cash 321 |
| Piccolo und mehr | Georg Pipps | Geislweg 14 |
| Princesa Isabel Vinhoss | Isabel de Castro | Estrada da saúde n. 58 |
| Que Delícia | Bernardo Batista | Rua da Panificadora, 12 |
| Queen Cozinha | Lúcia Carvalho | Alameda dos Canàrios, 891 |
| QUICK-Stop | Horst Kloss | Taucherstraße 10 |
| Rancho grande | Sergio Gutiérrez | Av. del Libertador 900 |
| Rattlesnake Canyon Grocery | Paula Wilson | 2817 Milton Dr. |
| Reggiani Caseifici | Maurizio Moroni | Strada Provinciale 124 |
| Ricardo Adocicados | Janete Limeira | Av. Copacabana, 267 |
| Richter Supermarkt | Michael Holz | Grenzacherweg 237 |
| Romero y tomillo | Alejandra Camino | Gran Vía, 1 |
| Santé Gourmet | Jonas Bergulfsen | Erling Skakkes gate 78 |
| Save-a-lot Markets | Jose Pavarotti | 187 Suffolk Ln. |
| Seven Seas Imports | Hari Kumar | 90 Wadhurst Rd. |
| Simons bistro | Jytte Petersen | Vinbæltet 34 |
| Spécialités du monde | Dominique Perrier | 25, rue Lauriston |
| Split Rail Beer & Ale | Art Braunschweiger | P.O. Box 555 |
| Suprêmes délices | Pascale Cartrain | Boulevard Tirou, 255 |
| The Big Cheese | Liz Nixon | 89 Jefferson Way Suite 2 |
| The Cracker Box | Liu Wong | 55 Grizzly Peak Rd. |
| Toms Spezialitäten | Karin Josephs | Luisenstr. 48 |
| Tortuga Restaurante | Miguel Angel Paolino | Avda. Azteca 123 |
| Tradição Hipermercados | Anabela Domingues | Av. Inês de Castro, 414 |
| Trail’s Head Gourmet Provisioners | Helvetius Nagy | 722 DaVinci Blvd. |
| Vaffeljernet | Palle Ibsen | Smagsløget 45 |
| Victuailles en stock | Mary Saveley | 2, rue du Commerce |
| Vins et alcools Chevalier | Paul Henriot | 59 rue de l’Abbaye |
| Die Wandernde Kuh | Rita Müller | Adenauerallee 900 |
| Wartian Herkku | Pirkko Koskitalo | Torikatu 38 |
| Wellington Importadora | Paula Parente | Rua do Mercado, 12 |
| White Clover Markets | Karl Jablonski | 305 – 14th Ave. S. Suite 3B |
| Wilman Kala | Matti Karttunen | Keskuskatu 45 |
| Wolski | Zbyszek | ul. Filtrowa 68 |
| Exotic Liquid | Charlotte Cooper | 49 Gilbert St. |
| New Orleans Cajun Delights | Shelley Burke | P.O. Box 78934 |
| Grandma Kelly’s Homestead | Regina Murphy | 707 Oxford Rd. |
| Tokyo Traders | Yoshi Nagase | 9-8 Sekimai Musashino-shi |
| Cooperativa de Quesos ‘Las Cabras’ | Antonio del Valle Saavedra | Calle del Rosal 4 |
| Mayumi’s | Mayumi Ohno | 92 Setsuko Chuo-ku |
| Pavlova, Ltd. | Ian Devling | 74 Rose St. Moonie Ponds |
| Specialty Biscuits, Ltd. | Peter Wilson | 29 King’s Way |
| PB Knäckebröd AB | Lars Peterson | Kaloadagatan 13 |
| Refrescos Americanas LTDA | Carlos Diaz | Av. das Americanas 12.890 |
| Heli Süßwaren GmbH & Co. KG | Petra Winkler | Tiergartenstraße 5 |
| Plutzer Lebensmittelgroßmärkte AG | Martin Bein | Bogenallee 51 |
| Nord-Ost-Fisch Handelsgesellschaft mbH | Sven Petersen | Frahmredder 112a |
| Formaggi Fortini s.r.l. | Elio Rossi | Viale Dante, 75 |
| Norske Meierier | Beate Vileid | Hatlevegen 5 |
| Bigfoot Breweries | Cheryl Saylor | 3400 – 8th Avenue Suite 210 |
| Svensk Sjöföda AB | Michael Björn | Brovallavägen 231 |
| Aux joyeux ecclésiastiques | Guylène Nodier | 203, Rue des Francs-Bourgeois |
| New England Seafood Cannery | Robb Merchant | Order Processing Dept. 2100 Paul Revere Blvd. |
| Leka Trading | Chandra Leka | 471 Serangoon Loop, Suite #402 |
| Lyngbysild | Niels Petersen | Lyngbysild Fiskebakken 10 |
| Zaanse Snoepfabriek | Dirk Luchte | Verkoop Rijnweg 22 |
| Karkki Oy | Anne Heikkonen | Valtakatu 12 |
| G’day, Mate | Wendy Mackenzie | 170 Prince Edward Parade Hunter’s Hill |
| Ma Maison | Jean-Guy Lauzon | 2960 Rue St. Laurent |
| Pasta Buttini s.r.l. | Giovanni Giudici | Via dei Gelsomini, 153 |
| Escargots Nouveaux | Marie Delamare | 22, rue H. Voiron |
| Gai pâturage | Eliane Noz | Bat. B 3, rue des Alpes |
| Forêts d’érables | Chantal Goulet | 148 rue Chasseur |
참고
W3C School - SQL IS NOT NULL Keywords
W3C School - SQL Tutorial
공부 목적 블로그