SQL Editor

Tables and Columns 

Task:

List all suppliers without a fax number. Return records where Fax is NULL and also where Fax = '' (empty string).
Click here for details on NULLIF.
 
 13 Records
CompanyName City Country Phone Fax
New Orleans Cajun Delights New Orleans USA (100) 555-4822 NULL
Heli Süßwaren GmbH & Co. KG Berlin Germany (010) 9984510 NULL
Plutzer Lebensmittelgroßmärkte AG Frankfurt Germany (069) 992755 NULL
Bigfoot Breweries Bend USA (503) 555-9931 NULL
Svensk Sjöföda AB Stockholm Sweden 08-123 45 67 NULL
Leka Trading Singapore Singapore 555-8787 NULL
Karkki Oy Lappeenranta Finland (953) 10956 NULL
Ma Maison Montréal Canada (514) 555-9022 NULL
Escargots Nouveaux Montceau France 85.57.00.07 NULL
eli lilly indianapolis USA NULL NULL
eli lilly indianapolis USA NULL NULL
Oxford Trading Oxford UK NULL NULL
Aimmazing Bayswater UK NULL NULL
Products
Pricing
Demos
Tutorials
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Licensing       EULA       Sitemap      
© Data & Object Factory, LLC.
Made with    in Austin, Texas.      Vsn 1.3.0