SQL And 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 AND operator is Logical operator.The AND operator returns TRUE if all the statements separated by AND are TRUE.

Syntax

SELECT 

       [ID]

      ,[Category]

      ,[SubCategory]

      ,[Type]

      ,[Direction]

      ,[Model]

      ,[Side]

      ,[Supplier]

      ,[ItemCode]

      ,[ItemName]

      ,[PurchasePrice]

      ,[ReorderPoint]

      ,[OpeningStock]

      ,[Location]

      ,[MeasurementUnit]

  FROM [tbl_ItemR]

   WHERE PurchasePrice > 8000 and OpeningStock > 0

The result of above SQL Statement is shown in Fig. below.

The Result returned by the above query shows all items where the purchasing price is greater than 8000 and opening stock is greater than 0.

For further question please mail: brainstormiert@gmail.com

SQL Between and Not Between Operators
SQL Any Operator
SQL All Operator