About (!= and <>)

Here is the answer – Technically there is no difference between != and <>. Both of them work the same way and there is absolutely no difference in terms of performance or result.

Here is the follow up question I received right I answer that there is no difference between those operator.

If != and <> both are the same, which one should be used in SQL queries?

Here is the answer – You can use either != or <> both in your queries as both technically same but I prefer to use <> as that is SQL-92 standard.

Though, many of the leading database applications supports both of the operators. For example -

• SQL Server
• MySQL
• Oracle
• SQLite
• Sybase
• IBM Informix
• PostgreSQL

Here is my return question to you which one of the following operators you use for NOT EQUAL TO operation?

1. !=
2. <>