想要实现和前一天对比,上升有绿箭头下降有红箭头select a.km,a.kmhz,a.rcyl,a.rq, b.rzsl from(select km,kmhz,rcyl,rqfrom D1401@xxzx where dm='合计' AND rq=TO_DATE('2025-10-28', 'yyyy-mm-dd')order by km)aleft join (select a.zwkm, a.km, a.rq, a.qdfs, a.rzsl, a.px from (select * from tab_rbb_zsj where qdfs='小计' and rq = to_date('2025-04-10', 'yyyy-mm-dd') ) a--(当前日期) ) b on a.km=b.km