Yeah, the scalar max returns null if any of the arguments are null, unlike the aggregate max that ignores null values. (and IFNULL is just an alternate spelling of coalesce). That does fix the "typing twice" but still results in "execute twice".
Yeah, the scalar max returns null if any of the arguments are null, unlike the aggregate max that ignores null values. (and IFNULL is just an alternate spelling of coalesce). That does fix the "typing twice" but still results in "execute twice".