Code has been added to clipboard!

How to Use SQL Not Equal Operator

Reading time 1 min
Published Sep 17, 2019
Updated Oct 3, 2019

What Is Not Equal in SQL

The SQL Not Equal operator belongs to the group of comparison operators which means it can be used to compare expressions. In this case, an expression is a combination of symbols that has a single data value. It can be variables, constants, columns or scalar functions.

As SQL Not Equal is a binary operator, it cannot be used to compare more than two expressions at once.

Udacity
Pros
  • Simplistic design (no unnecessary information)
  • High-quality courses (even the free ones)
  • Variety of features
Main Features
  • Nanodegree programs
  • Suitable for enterprises
  • Paid certificates of completion
Udemy
Pros
  • Easy to navigate
  • No technical issues
  • Seems to care about its users
Main Features
  • Huge variety of courses
  • 30-day refund policy
  • Free certificates of completion
Datacamp
Pros
  • Great user experience
  • Offers quality content
  • Very transparent with their pricing
Main Features
  • Free certificates of completion
  • Focused on data science skills
  • Flexible learning timetable

Return Values of SQL Not Equal

SQL Not Equal is a boolean operator. That means its return value can be either True (if one expression in SQL does not equal the other) or False (if the expressions are equal).

If either of the expressions has a NULL value, the SQL Not Equal will also return Null:

Sql Not Equal

Two Types of Syntax for Not Equal

There are two ways to write the SQL Not Equal operator:

Example
exp <> exp
exp != exp

Both of them achieve the same result. However, we recommend you to use the first type of syntax, as it complies with the ISO standard, while the second one does not.