通过子查询建表的例子 sql>CREATE TABLE emp_41 AS SELECT id,last_name,userid,start_date FROM s_emp WHERE dept_id = 41;
http://blog.csdn.net/haiross/article/details/11772847/
