SELECT MAX(DATE_START) AS effectivestarttime,
RULE AS rule,
CONDITIONS AS condition
FROM
MGRSCHEMA.APPROVE
WHERE
CONDITIONS = '2001'
AND RULE = '2001'
GROUP BY
CONDITIONS,
RULE
MAX(DATE_START)查询出的最大值为空 用0代替 请各位大神帮帮忙
SELECT
case when MAX(DATE_START)==null then 0 else MAX(DATE_START) AS effectivestarttime end
,RULE AS rule
,CONDITIONS AS condition
FROM
MGRSCHEMA.APPROVE
WHERE
CONDITIONS = '1'
AND RULE = '1'
GROUP BY
CONDITIONS,
RULE