What is this symbol in an SQL query?

where _c1.name<>c2.name
开发者_Go百科

I am confused with the symbol <>. Please explain its meaning.

---

Greater than and less than.

In other words not equal to aka !=.

To put it rather confusingly != = <> , yes they can be used interchangeably.

---

It means different. Your clause indicates that _c1 and c2 must not have the same name value.

---

It means "not equal to". It is an alternative to using !=. Here is a list of the operators used in SQL Server.

It comes from meaning < less than or > greater than. i.e. anything but equal.