Re: 子查询case when 问题

Hi： I can't understand the problem you described. Please clearly describe your SQL statement and provide a screenshot of the query when there is a problem and a comparison between the correct result and the wrong result. In addition, providing the kylin version you are using can help others

子查询case when 问题

子查询case when 问题：子查询嵌套后聚合值丢失，子查询中多个case when最后结果只有case when中的第一行值，且对case when后的值筛选不生效；另外一条语句最后返回success，但无结果数据发自我的荣耀手机