select into table 和create table as
select [name],[id],[country] into [new_sanguo] from [sanguo]
where [sex]='Male'
复制[sanguo]中所有[sex]='Male'的数据
sql server
而
create table new_sanguo as
select [name],[id],[country] from [sanguo] where [sex]='Male'
oracle 复制语句