为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】:linux
【CPU】:麒麟v10
【问题描述】*:执行sql报错The level of nested set function is too deeply该怎么解决
SELECT max(id) as id,
max(model_id) as model_id,
max(model_key) as model_key,
max(account_id) as account_id,
max(create_time) as create_time,
max(create_time) as create_time,
min(show_flag) as show_flag
FROM t_cmdb_entity_model_show
GROUP BY model_id,
model_key
HAVING min(show_flag) = 1
这种是通过group by的聚合函数就已经够了,再加一个having的话就会报嵌套的聚合函数过深,把having去掉,然后外层再加一层select应该可以不会报错。