查询两个条件的情况
SELECT
*
FROM
investmenttab
WHERE
( investment, investdays ) =
( SELECT
investment,
investdays
FROM
investmenttab
WHERE
investmentlistid = 'ph-000000001' );
将查询结果直接存储到新表中(新表未创建)
create table temp as
select ename from employee_new
;