oracle 创建带数据的表

create table  siebel.liu_pricelist2 as
SELECT
customerid,
customername,
pricelistname
FROM siebel.liu_pricelist group by customerid,customername,pricelistname