SELECT gid,price,date,row_number() OVER(PARTITION BY gid,n1) X from( SELECT *,price-(min(price) over(PARTITION BY gid order by date rows BETWEEN unbounded preceding AND CURRENT ROW)) n1 from goods ORDER by gid,date)a
点赞 2

相关推荐

牛客网
牛客企业服务