SQL Any 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 ANY operator is Logical operator.The ANY operator returns TRUE if any 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 = ANY (SELECT PurchasePrice FROM [tbl_ItemR] WHERE PurchasePrice >= 4000);

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

The result set shows that purchase price of any item(s) is greater than or equal to 4000, returned by ANY Operator.

For further question please mail: brainstormiert@gmail.com

SQL Between and Not Between Operators
SQL All Operator
SQL And Operator