orcale 上一条,下一条
LAG(PUBLISHDATE, 1) OVER ( PARTITION BY b.FSYMBOL ORDER BY PUBLISHDATE) AS begin_date
LEAD(PUBLISHDATE, 1) OVER ( PARTITION BY b.FSYMBOL ORDER BY PUBLISHDATE) AS begin_date
LAG(PUBLISHDATE, 1) OVER ( PARTITION BY b.FSYMBOL ORDER BY PUBLISHDATE) AS begin_date
LEAD(PUBLISHDATE, 1) OVER ( PARTITION BY b.FSYMBOL ORDER BY PUBLISHDATE) AS begin_date