rows between unbounded preceding and current row等，unbounded ，preceding ，following，current row含义详解

作者：知新_RL | 2024-06-22 08:24:33

踩

unbounded preceding

unbounded：无界限

preceding：从分区第一行头开始，则为 unbounded。 N为：相对当前行向前的偏移量

following ：与preceding相反,到该分区结束，则为 unbounded。N为：相对当前行向后的偏移量

current row：顾名思义，当前行，偏移量为0

例子：

partition by  order by asc/desc rows between unbounded preceding and current row

partition by order by asc/desc rows between 1 preceding and 1 following

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/知新_RL/article/detail/745947