Tech Junkie Blog - Real World Tutorials, Happy Coding!: SQL: The IN Operator

Tuesday, May 25, 2021

SQL: The IN Operator

The IN operator in SQL means that you are retrieving records in the database that matches the values in a comma separated list. Here is an example of how you can use the IN operator in the products table in the Northwind database.

SELECT * 
FROM Products
WHERE SupplierID IN (1,2)

In the above example all the products with the SupplierID of 1 or 2 are retrieved.



SQL results from IN operator query


Similar Posts:
Previous: SQL: Using Parentheses To Get Expected Result
Next: SQL: The NOT IN Operator

5 comments:

Subscribe to: Post Comments (Atom)

Search This Blog