Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is the SQL operator name for "<>"?

Tags:

operators

sql

I am confused and did not find in Google. Can anyone tell me What is Sql <> operator name?

like image 618
Great User Avatar asked Mar 02 '13 21:03

Great User


People also ask

What is the <> operator in SQL?

An operator is a reserved word or a character used primarily in an SQL statement's WHERE clause to perform operation(s), such as comparisons and arithmetic operations. These Operators are used to specify conditions in an SQL statement and to serve as conjunctions for multiple conditions in a statement.

What is the use of <> operator?

An operator is used to manipulate individual data items and return a result. These items are called operands or arguments.

Is != and <> same in SQL?

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.


2 Answers

<> is NOT Equal to, it's the same as !=

like image 63
steoleary Avatar answered Sep 23 '22 01:09

steoleary


It's "not equal". Look in the list of operators for the database you're using, and find the appropriate section (usually "comparison operators"). For example:

  • SQL server
  • MySQL
  • Oracle
  • Postgres
like image 20
Jon Skeet Avatar answered Sep 20 '22 01:09

Jon Skeet