여러분이 사용하고 계신 브라우저는 HTML5를 지원하지 않기 때문에 몇몇 요소가 제대로 보이도록 JScript를 사용하고 있습니다. 하지만 여러분의 브라우저 설정에서 스크립트 기능이 꺼져있으므로, 현재 페이지를 제대로 확인하시려면 스크립트 기능을 켜주셔야 합니다. SQL - 참조 - 키워드 - IS NOT NULL
SQL – 참조 – 키워드 – IS NOT NULL
2년전 작성
11개월전 수정

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
참고

Mingg`s Diary
밍구
공부 목적 블로그