I have a question about unique vs. distinct
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)
column1 entry 0011 should not show up because it doesn't have a duplicate.
When I use unique (not duplicated)
column1 entry 0011 shows up
Why is this occurring ?
Unique vs. Distinct
-
anmac1789
- Posts: 747
- Joined: Mon Aug 24, 2020 1:16 pm
Unique vs. Distinct
You do not have the required permissions to view the files attached to this post.
-
void
- Developer
- Posts: 19903
- Joined: Fri Oct 16, 2009 11:31 pm
Re: Unique vs. Distinct
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.
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
- Posts: 747
- Joined: Mon Aug 24, 2020 1:16 pm
Re: Unique vs. Distinct
alright, thank you voidvoid wrote: Wed May 14, 2025 12:57 am 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.
-
win32
- Posts: 44
- Joined: Fri Mar 19, 2021 11:48 am
Re: Unique vs. 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.
-ignore me if I missunderstood your quesiton.
-
anmac1789
- Posts: 747
- Joined: Mon Aug 24, 2020 1:16 pm
Re: Unique vs. Distinct
do you mean right click and selecting find duplicates (including 1st one) and then right click again and selecting unique (including 1st one) ?win32 wrote: Wed May 14, 2025 5:56 pm 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.
-
void
- Developer
- Posts: 19903
- Joined: Fri Oct 16, 2009 11:31 pm
Re: Unique vs. Distinct
You will need to do two passes:
Find duplicates first, then find distinct.
Yes, This is what I meant to say.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.
Sorry if I wasn't clear.
-
anmac1789
- Posts: 747
- Joined: Mon Aug 24, 2020 1:16 pm
Re: Unique vs. Distinct
its okay, I understoodvoid wrote: Thu May 15, 2025 12:23 amYou will need to do two passes:
Find duplicates first, then find distinct.Yes, This is what I meant to say.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.
Sorry if I wasn't clear.