mark一下,GCK。
# 拉链
select
*
from table_name
where start_date <= $date
and end_date > $date
# 切片
select pa.*
from (
select *,row_number() over(partition by col_name order by data_date desc) rn
from table_name
where data_date <= $date
) pa
where pa.rn = 1