Re: count(distinct col) can't recognize distinct
Can you give a specific example of a query that doesn't do what you expect
it to do?
Le mar. 13 nov. 2018 à 07:56, 大明 <zteny@xxxxxxxxxxx> a écrit :
> Hi Guys:
> I got a question why it can't recognize DISTINCT tag on COUNT(DISTINCT
> col) aggregation function sometimes.
> but it is not problem when my sql query statement have WHEN clause or one
> more aggregation functions.
> Best Regards
> Haochao Zhuang