SQL Editor

SQL Left Supplier Example

Task:

List suppliers with abbreviated, two-letter countries.
Click here for details on LEFT.
 
 29 Records
CompanyName City Country
Exotic Liquids London UK
New Orleans Cajun Delights New Orleans US
Grandma Kelly's Homestead Ann Arbor US
Tokyo Traders Tokyo JA
Cooperativa de Quesos 'Las Cabras' Oviedo SP
Mayumi's Osaka JA
Pavlova, Ltd. Melbourne AU
Specialty Biscuits, Ltd. Manchester UK
PB Knäckebröd AB Göteborg SW
Refrescos Americanas LTDA Sao Paulo BR
Heli Süßwaren GmbH & Co. KG Berlin GE
Plutzer Lebensmittelgroßmärkte AG Frankfurt GE
Nord-Ost-Fisch Handelsgesellschaft mbH Cuxhaven GE
Formaggi Fortini s.r.l. Ravenna IT
Norske Meierier Sandvika NO
Bigfoot Breweries Bend US
Svensk Sjöföda AB Stockholm SW
Aux joyeux ecclésiastiques Paris FR
New England Seafood Cannery Boston US
Leka Trading Singapore SI
Lyngbysild Lyngby DE
Zaanse Snoepfabriek Zaandam NE
Karkki Oy Lappeenranta FI
G'day, Mate Sydney AU
Ma Maison Montréal CA
Pasta Buttini s.r.l. Salerno IT
Escargots Nouveaux Montceau FR
Gai pâturage Annecy FR
Forêts d'érables Ste-Hyacinthe CA
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.