SELECT TRANSID 交易编码,
to_CHAR( MIN(ACCEPTTIME),'yyyy-mm-dd hh24:mi:ss,ff3') 接受请求时间,
to_CHAR( MIN(TRANSDATE),'yyyy-mm-dd hh24:mi:ss,ff3') 推送结果时间,
EXTRACT(SECOND FROM(MAX(TRANSDATE) - MIN(ACCEPTTIME))) * 1000 处理耗时,
EXTRACT(SECOND FROM(MAX(TRANSDATE) - MIN(TRANSDATE))) * 1000 推送耗时
FROM TEST
GROUP BY TRANSID
ORDER BY 接受请求时间