回复 16# zihowe select acctno,bal,trandate1,LEAD(trandate1,1,'2012-12-31')OVER(ORDER BY trandate1) AS trandate2from(values(102012011,81.23,'2010-01-03'),(102012011,100.21,'2010-01-05'),(102012011,481.23,'2010-02-04'),(102012011,1300.21,...显示全部
SELECT a.*, b.trandate2 FROM ( SELECT row_number() over(order by trandate) arow, acctno, &nb...显示全部
SELECT a.*, b.trandate2 FROM ( SELECT row_number() over(order by trandate) arow, acctno, bal, trandate FROM 表1 ) a LEFT OUTER JOIN ( SELECT row_number() over(order by trandate) brow, trandate trandate2 FROM 表1 ) b ON a.arow= b.arow-1收起