SQL GREATER THAN or EQUAL TO 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 GREATER THAN or EQUAL TO operator is Comparison operator.The GREATER THAN or EQUAL TO  operator returns the record based on condition on right side of the >= signs.


Syntax
SELECT 
       [ID]
      ,[Category]
      ,[SubCategory]
      ,[Type]
      ,[Direction]
      ,[Model]
      ,[Side]
      ,[Supplier]
      ,[ItemCode]
      ,[ItemName]
      ,[PurchasePrice]
      ,[ReorderPoint]
      ,[OpeningStock]
      ,[Location]
      ,[MeasurementUnit]
  FROM [tbl_ItemR]
   WHERE ID >= 360;

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

 As the image above shows the record where ID is greater than or equal to 360, which also includes the record at 360.

 For further question please mail: brainstormiert@gmail.com