SQL NOT 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 NOT EQUAL TO operator is Comparison operator.The NOT 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 <> 10;

The result of above SQL Statement is shown in Fig. below.
As the image above shows the record where ID is not equal to 10, which excludes the record at 10.

For further question please mail: brainstormiert@gmail.com