osdir.com


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

count(distinct col) can't recognize distinct


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