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
Additional Resources
To learn more about SQL Not Equals (<>), check out these useful resources: