Menu
Community /Pin to ProfileBookmark
@NogDogJan 07.2021 — #Not 100% sure this is what you need, but you can include a "distinct" within the count() itself, e.g.:
@NogDogJan 07.2021 — #You may need to do a sub-query to do the distinct-ing (to coin a word). This is off the top of my head, so no guarantees:
Double Count in JOIN
I have a few tables I’m joining together.
What I’m doing is counting rows from my master FROM table.
But doing a bunch of JOINS, WHERE’s GROUP to filter and find data I want to count.
Sometimes an applicable row is referenced twice in my query. How can I make it so it’s only counted **once
Almost like a distinct in my CASE or COUNT.
“`
CASE WHEN w.ColumnField = 1 THEN SUM(d.thisField) ELSE 0 END as MyCount,
COUNT(d.thisId) as MySecondCount,
Sign in
to post a comment4 Comments(s) ↴
0
@NogDogJan 07.2021 — #Not 100% sure this is what you need, but you can include a "distinct" within the count() itself, e.g.:<i>
</i>COUNT(DISTINCT d.thisId) as MySecondCount,
0
@NogDogJan 07.2021 — #You may need to do a sub-query to do the distinct-ing (to coin a word). This is off the top of my head, so no guarantees:<i>
</i>select sum(x.value)
from (
select distinct
ColumnName,
case when ColumnName = 1 then FieldName end as value
from RelevantTable -- where, etc....
) as x
-- joins, etc.
-- where, etc.