SQL All 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 ALL operator is Logical operator.The ALL operator returns TRUE if all of the subquery values meet the condition.

Syntax

SELECT 
       [ID]
      ,[Category]
      ,[SubCategory]
      ,[Type]
      ,[Direction]
      ,[Model]
      ,[Side]
      ,[Supplier]
      ,[ItemCode]
      ,[ItemName]
      ,[PurchasePrice]
      ,[ReorderPoint]
      ,[OpeningStock]
      ,[Location]
      ,[MeasurementUnit]
  FROM [tbl_ItemR]
   WHERE PurchasePrice > ALL (SELECT PurchasePrice FROM [tbl_ItemR] WHERE PurchasePrice < 3000);

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


The result set shows that purchase price of all items is greater than 3000, returned by ALL Operator.

 For further question please mail: brainstormiert@gmail.com


SQL Between and Not Between Operators
SQL Any Operator
SQL And Operator