SQL WHERE IN Clause
SQL WHERE IN Clause WHERE IN returns values that matches values in a list or subquery. WHERE IN is a shorthand for multiple OR conditions. The definitive guide for data professionals The SQL WHERE IN syntax The general syntax is: SELECT column-names FROM table-name WHERE column-name IN (values) PRODUCT Id ProductName SupplierId UnitPrice Package IsDiscontinued SQL WHERE IN Examples Problem: List all suppliers from the USA, UK, OR Japan SELECT Id, CompanyName, City, Country FROM Supplier WHERE Country IN ('USA', 'UK', 'Japan') Results: 8 records. Id CompanyName City Country 1 Exotic Liquids London UK 2 New Orleans Cajun Delights New Orleans USA 3 Grandma Kelly's Homestead Ann Arbor USA 4 Tokyo Traders Tokyo Japan 6 Mayumi's Osaka Japan 8 Specialty Biscuits, Ltd. Manchester UK 16 Bigfoot Breweries Bend USA 19 New England Seafood Cannery Boston USA PRODUCT Id ProductName Su...