SQL IN Operator

Types of SQL Operators

SQL Arithmetic Operators

  1. ADD
  2. Subtract
  3. Multiple
  4. Divide
  5. Modulo

SQL Bitwise Operators

  1. And
  2. OR
  3. exclusive OR

SQL Comparison Operators

  1. Equal to
  2. Greater than
  3. Less than
  4. Greater than or Equal to
  5. Less than or Equal to
  6. Not equal to

SQL Logical Operators

  1. All
  2. And
  3. Any
  4. Between
  5. Exists
  6. In
  7. Like
  8. Not
  9. OR
  10. Some

SQL ALL Operator 

The IN operator is Logical operator.The IN operator returns TRUE if  operand is equal to one of the expressions in the list.

 Syntax
SELECT 
       [ID]
      ,[Category]
      ,[SubCategory]
      ,[Type]
      ,[Direction]
      ,[Model]
      ,[Side]
      ,[Supplier]
      ,[ItemCode]
      ,[ItemName]
      ,[PurchasePrice]
      ,[ReorderPoint]
      ,[OpeningStock]
      ,[Location]
      ,[MeasurementUnit]
  FROM [tbl_ItemR]
   WHERE Category IN ('General');


The result of above SQL Statement is shown in Fig. below.
The Result returned by the above query shows all items where the Category is General.

 For further question please mail: brainstormiert@gmail.com