【每日一题】SQL 知识大测验 | 持续更新
38题 select * , case when id%2 =1 and name_2 is not null then name_2 when id%2 =0 then name_4 else name_id end as name_3 from ( select *,Lead(name_id) over(order by id) as name_2 ,Lag(name_id) over(order by id) as name_4 from test )a
赞1
踩0