select a.batchdate "日期",
a.batchtime "启动时间",
case a.state
when 'R' then '报错'
when 'A' then '执行中'
when 'G' then '成功'
when 'X' then '手工取消'
else '未知' end "执行状态 "
from "SAPSR3"."RSPCPROCESSLOG" as a left join "SAPSR3"."RSPCLOGCHAIN" as b
on a.log_id = b.log_id
where b.CHAIN_ID='CWJGDSJ_QD1'
group by a.batchdate,a.state,a.batchtime
order by a.batchdate desc,a.state desc, a.batchtime asc
limit 1