I have seen SQL
that uses both !=
and <>
for not equal. What is the preferred syntax and why?
I like !=
, because <>
reminds me of Visual Basic
.
Most databases support !=
(popular programming languages) and <>
(ANSI).
Databases that support both !=
and <>
:
!=
and <>
!=
and <>
!=
and <>
!=
and <>
!=
and <>
!=
and <>
!=
and <>
!=
and <>
!=
and <>
Databases that support the ANSI standard operator, exclusively: