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: 

>