Description
We can remove the distinct in aggregate expression if the child distinct semantics is guaranteed.
For example:
SELECT count(distinct c) FROM ( SELECT c FROM t GROUP BY c )
We can remove the distinct in aggregate expression if the child distinct semantics is guaranteed.
For example:
SELECT count(distinct c) FROM ( SELECT c FROM t GROUP BY c )