运行以下命令时如何返回 0 而不是 null:
SELECT MAX(X) AS MaxX FROM tbl WHERE XID = 1
(假设没有XID=1的行)
or:
SELECT coalesce(MAX(X), 0) AS MaxX FROM tbl WHERE XID = 1