SQL Not Equal <> Comparison Operator

We use SQL Not Equal comparison operator (<>) to compare two expressions. For example, 10<>11 comparison operation uses SQL Not Equal operator (<>) between two expressions 10 and 11.

Difference between SQL Not Equal Operator <> and !=

We can use both SQL Not Equal operators <> and != to do inequality test between two expressions. Both operators give the same output. The only difference is that ‘<>’ is in line with the ISO standard while ‘!=’ does not follow ISO standard. You should use <> operator as it follows the ISO standard.

Let’s set up a sample table to explore SQL Not Equal operator.

Vous aimerez aussi...