select into指令

• select 指令也可以產生新的資料表

• select [list] into 新資料表 where 條件

• SELECT * into largehost from net11 where 欄位8 > 10000000;

• select nstrunv.engs,nstrunv.chap,nstrunv.sec,nstrunv.txt,nstrkjv.txt into john from nstrunv,nstrkjv where nstrunv.id=nstrkjv.id and nstrunv.engs='John' order by nstrunv.chap, nstrunv.sec;