create table lee_0710_book2 as select * from LEE_BOOK
partition by range(bookprice)
(
partition part1 values less than(30),
partition part2 values less than(maxvalue)
);
partition by range(bookprice)
(
partition part1 values less than(30),
partition part2 values less than(maxvalue)
);
create table lee_0710_book2
partition by range(bookprice)
(
partition part1 values less than(30),
partition part2 values less than(maxvalue)
)
as select * from LEE_BOOK
;