create table x(no number,name varchar(30),age number) partition by (age)( partition a values less than (30), partition b values less than (50), partition max_v values less than (maxvalue) ); select * from x partition (a) where age <25; 这样就可以从a分区里面查找出来小于25的数据了。
partition a values less than (30),
partition b values less than (50),
partition max_v values less than (maxvalue)
);
select * from x partition (a) where age <25;
这样就可以从a分区里面查找出来小于25的数据了。
select * from test partition(p1)