where条件查询
SELECT
APPLY_CD,
MIN (DELIVERY_DATE)
FROM
(
SELECT
WBID.APPLY_CD AS APPLY_CD,
BNTI.DELIVERY_DATE AS DELIVERY_DATE
FROM
WAS_BIZ_INFO_DETAIL WBID
INNER JOIN BOP_NOTF_TASK_INSTANCE BNTI ON WBID.PROCESS_INSTANCE = BNTI.SOURCE_INSTANCE_ID
WHERE
BNTI.SUBJECT IN (
'R1200',
'R3200',
'N1100',
'A1100'
)
ORDER BY
BNTI.DELIVERY_DATE DESC
)
GROUP BY
APPLY_CD
case条件查询
SELECT
APPLY_CD,
MIN(
CASE
WHEN BNTI.SUBJECT IN (
'R1200',
'R3200',
'N1100',
'A1100'
) THEN BNTI.DELIVERY_DATE END
) DELIVERY_DATE
FROM
WAS_BIZ_INFO_DETAIL WBID
INNER JOIN BOP_NOTF_TASK_INSTANCE BNTI ON WBID.PROCESS_INSTANCE = BNTI.SOURCE_INSTANCE_ID
GROUP BY
APPLY_CD
很明显出现了空行,而且查询的条数不对劲。
再此先谢谢各位大神的帮助。