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 复制语句