需求:
现需通过sql获取该公司在第a天的收盘价,若第a天无收盘价记录,则取该日期之前,最近的一个收盘价作为第a天的收盘价(例如:,2019-10-05的收盘价取2019-09-30的54.22)
数据:
目标结果:
sql:
select
price_date,
price,
first_value(price) over(partition by first_price_date order by price_date)
from
(
select
price_date,
price,
max(case when price is not null then price_date end) over(order by price_date) as first_price_date
from t1
) t;