What is the exact Difference between <> and != ?
None whatsoever, syntactically.
Both are inequality operators, <>
is the SQL-92 standard, however its interchangable on some platforms with !=
(E.g. SQL Server)
<>
is the only inequality operator in the SQL Standard.
Lot's of SQL database systems support the use of !=
including PostgreSQL, SQL Server, MySQL, SQLite, Oracle & Firebird, but some don't, including Apache Derby.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With