指定分区
PARTITION BY RANGE_N(DAY_ID BETWEEN 20130101 AND 20181231 EACH 1 )
分页
qualify row_number() over(order by display_order) >= 1 and row_number() over(order by display_order) <= 18
复制表
create table a as b
指定分区
PARTITION BY RANGE_N(DAY_ID BETWEEN 20130101 AND 20181231 EACH 1 )
分页
qualify row_number() over(order by display_order) >= 1 and row_number() over(order by display_order) <= 18
复制表
create table a as b
转载于:https://my.oschina.net/liyonglee/blog/600530