Hi there, Use kylin insight submit below sentence, ------------------------------------------select sentence------------------------------------------ select count(distinct memberid) as memberid, count(distinct case when issuccess=1 then memberid else -1 end) as Xmemberid from tables where istest=0 and isvalid=1 and createdate>='2017-03-08'
results memberid Xmemberid 863049 863049 ------------------------------------ retrun the same results,if add condittion include where the results is ------------------------------------------------------condittion in where --------------------------------- select count(distinct memberid) as Xmemberid from tables where istest=0 and isvalid=1 and issuccess=1 and createdate>='2017-03-08' results memberid 637290 ---------------------------------- Why appear this problem,anyone has encountered a similar situcation? Best Regards Roy
