SQL Not Equals Comparison Operator

The SQL Not Equals comparison operator (<>) is used to compare two values.  It returns a TRUE if the first value is Not Equal the second. 

Here are a couple of examples: 

10 <> 5 TRUE 
5 <> 5 FALSE 
‘M’ <> ‘F’ TRUE 

Here is an example using Not Equals (<>) to find all non-male employees 

SELECT NationalIDNumber       ,JobTitle       ,MaritalStatus       ,Gender   FROM HumanResources.Employee   WHERE Gender <> 'M' 
SELECT NationalIDNumber 
      ,JobTitle 
      ,MaritalStatus 
      ,Gender 
  FROM HumanResources.Employee 
  WHERE Gender <> 'M'

Additional Resources 

To learn more about SQL Not Equals (<>), check out these useful resources: 

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Are YOU READY TO START LEARNING SQL SERVER, BUT DON'T KNOW WHERE TO START?

Nothing is worse than, being excited to learn a new tool but not knowing where to start, wasting time learning the wrong features, and being overwhelmed .

But it doesn't have to be this way.

I'm Putting together a free email course to help you get started learning SQL Server.

Name*
Email*
Sign Up
>