Unique vs. Distinct

[anmac1789]

I have a question about unique vs. distinct

image.png (295.09 KiB) Viewed 2970 times

I am interested in column-1 entries. I want to find column1 entries which contain 1 or more duplicates only. Meaning,

0123 (does not have a duplicate therefore shall not be listed)
0110 + 0110 (+1 duplicate)
0210 + 0210 + 0210 (+2 duplicate)

How can I get this kind of result ?

When I use unique (including 1st duplicate)

image.png (46.71 KiB) Viewed 2970 times

column1 entry 0011 should not show up because it doesn't have a duplicate.


When I use unique (not duplicated)

image.png (25.19 KiB) Viewed 2970 times

column1 entry 0011 shows up

Why is this occurring ?

[void]

In Everything:
Unique = only one occurrence.
Distinct = only one occurrence OR first duplicated.

There's no option to find duplicated and only the first duplicated.
You will need to do two passes:
Find duplicates first, then find distinct.

[anmac1789]

In Everything:
Unique = only one occurrence.
Distinct = only one occurrence OR first duplicated.

There's no option to find duplicated and only the first duplicated.
You will need to do two passes:
Find duplicates first, then find distinct.

alright, thank you void

[win32]

also right clicking your "column 1" choosing "find duplicates", and then doing a second query could be of interest for you
-ignore me if I missunderstood your quesiton.

[anmac1789]

also right clicking your "column 1" choosing "find duplicates", and then doing a second query could be of interest for you
-ignore me if I missunderstood your quesiton.

do you mean right click and selecting find duplicates (including 1st one) and then right click again and selecting unique (including 1st one) ?

[void]

You will need to do two passes:
Find duplicates first, then find distinct.

also right clicking your "column 1" choosing "find duplicates", and then doing a second query could be of interest for you
-ignore me if I missunderstood your quesiton.

Yes, This is what I meant to say.
Sorry if I wasn't clear.

[anmac1789]

You will need to do two passes:
Find duplicates first, then find distinct.

also right clicking your "column 1" choosing "find duplicates", and then doing a second query could be of interest for you
-ignore me if I missunderstood your quesiton.

Yes, This is what I meant to say.
Sorry if I wasn't clear.

its okay, I understood