SELECT ORG_NO, 利润总额, NVL(LAG(a.利润总额) OVER (PARTITION BY a.ORG_NO ORDER BY a.数据日期 DESC),0) AS 上年利润总额, 数据日期 FROM(SELECT ROW...
