Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Difference between <> and != in SQL

Tags:

What is the exact Difference between <> and != ?

like image 220
Vijjendra Avatar asked May 02 '11 11:05

Vijjendra


2 Answers

None whatsoever, syntactically.

Both are inequality operators, <> is the SQL-92 standard, however its interchangable on some platforms with != (E.g. SQL Server)

like image 52
Alex K. Avatar answered Nov 27 '22 00:11

Alex K.


<> 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.

like image 36
Jon Hanna Avatar answered Nov 27 '22 01:11

Jon Hanna