SELECT
MAX(DATE_START) AS effectivestarttime
,RULE AS rule
,CONDITIONS AS condition
FROM
MGRSCHEMA.APPROVE
WHERE
CONDITIONS = '1'
AND RULE = '1'
GROUP BY
CONDITIONS,
RULE
如果最大值DATE_START是空值 用0替代 代码怎么写 请各位大神帮帮忙