Hi, I'm trying to create a query that allows me to find the differences between values inside a same table.
Let's suppose I have this table:
The query should return only these results:
I tried using WHERE NOT IN, but so far it did not work.
Any idea how to achieve this?
Thanks!
Let's suppose I have this table:
Client | Item |
A | 1 |
A | 2 |
A | 3 |
B | 1 |
B | 2 |
B | 4 |
The query should return only these results:
Client | Item |
A | 3 |
B | 4 |
I tried using WHERE NOT IN, but so far it did not work.
Any idea how to achieve this?
Thanks!