思路:
(1) 从交易表日期表中获得所有交易日期的前一交易日,并创建临时表
(2) 从临时表,中筛选,需要求解前一交易日期的交易日
代码:
WITH t AS (SELECT B.BK_DATE,lead(B.BK_DATE, 1, null) over (order by B.BK_DATE) AS next_trade_dt
FROM DIM_TIME B)
SELECT t.* FROM t
WHERE t.BK_DATE IN (SELECT A.TRAD_DATE FROM FA_BOND_TRADE A )
结果:
最终结果: