Mysql查询int型字段的最大值,表为空结果为null时处理成0

时间:2022-05-16 15:32:25

1.使用ifnull()函数,失败

如:SELECT ifnull(max(t.order_num), 0) FROM biodata.taxon as t where t.status='1';

报错:Caused by: org.hibernate.QueryException: No data type for node: org.hibernate.hql.internal.ast.tree.MethodNode

2.使用coalesce()函数,成功

如:SELECT coalesce(max(t.order_num), 0) FROM biodata.taxon as t where t.status='1';