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

转载于:https://www.cnblogs.com/huangll/archive/2012/10/16/2726353.html