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的数据了。