cognos 数据源需要自关联，每个保单取最新一天数据，求助！

select *
FROM F_LIFE_LONG_POLICY_DETAIL
WHERE APPLY_CODE, POLICY_CODE, DEADLINE_ID IN
(SELECT APPLY_CODE, POLICY_CODE, MAX(DEADLINE_ID)
     FROM F_LIFE_LONG_POLICY_DETAIL F_LIFE_LONG_POLICY_DETAIL
WHERE DEADLINE_ID IS NOT NULL
  GROUP BY APPLY_CODE, POLICY_CODE)收起