+ 1

Isn't the Not equal to operator denoted by <> in SQL?

In the content, Not equal to has been denoted by the symbol !=, whereas I believe in SQL, <> is the right symbol to perform not equals operation.

25th Nov 2017, 9:59 PM
Anjana K V
Anjana K V - avatar
1 Answer
+ 7
Both can be used although <> is more canonical, as it's ANSI-compliant. But for the sake of code portability both work alright.
25th Nov 2017, 10:08 PM
Kuba Siekierzyński
Kuba Siekierzyński - avatar