SQL最近价格涨幅排序

表： sku_price_modify_detail
字段：sku_id new_price change_date

需求： 查询最近一次商品价格涨幅情况，并按幅度升序排列

select sku_id,dp from (
    select 
     sku_id
     ,if(rn=1,new_price,0) - if(rn=2,new_price,0) dp
     
     from (
        select sku_id,new_price,change_date
         ,row_number() over(partition by sku_id order by change_date desc) rn
         from sku_price_modify_detail
    ) a
) b order by dp