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 reproduce this problem. > 在 2021年6月11日，14:58，[email protected] 写道： > > 子查询case when 问题： > 子查询嵌套后聚合值丢失，子查询中多个case when最后结果只有case when中的第一行值，且对case when后的值筛选不生效； > 另外一条语句最后返回success，但无结果数据 > > 发自我的荣耀手机
