Answer the question
In order to leave comments, you need to log in
Why does count always return 1?
Why does count together with group by always return 1?
select count(*) as aggregate from "products" group by "products"."id"
Answer the question
In order to leave comments, you need to log in
Probably because id is a unique field, and when grouping, exactly one is obtained.
But this is not accurate (you did not show what kind of plate you have).
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question