What Exactly does the <> operator do in HQL

Question

It doesn't say exactly in the docs. I have seen this refer to not equals in other instances but HQL already has !=

If it does mean not equals how is it different from != ?

I'm sorry if this question has been asked before, but I wasn't able to find an exact explanation for it.

https://stackoverflow.com/questions/5658457/not-equal-operator-on-null — Reimeus, Jun 02 '17 at 20:37

Mark Rotteveel · Accepted Answer · 2021-01-21T16:09:06.147

17

The SQL standard defines not equals as <>; HQL is SQL-like so follows suit.

Some database dialects (also) support != as the not equals operator, some only support !=, others only <>; but for dialects that support both, the behaviour is the same (at least, I am not aware of dialects where they behave differently).

edited Jan 21 '21 at 16:09

answered Jun 02 '17 at 20:42

Mark Rotteveel

100,966
191
140
197

Ok so <> is interchangeable with !=. Thanks – jyapx Jun 02 '17 at 20:46
2

Actually, `!=` is not part of the SQL standard (but most DBs support it) – Bohemian Jun 02 '17 at 20:50

What Exactly does the <> operator do in HQL

1 Answers1