chnhbhndchngn 2022-02-13 08:24:57 阅读数:936
Query two conditions
SELECT
*
FROM
investmenttab
WHERE
( investment, investdays ) =
( SELECT
investment,
investdays
FROM
investmenttab
WHERE
investmentlistid = 'ph-000000001' );
Store the query results directly in the new table ( New table not created )
create table temp as
select ename from employee_new
;
copyright:author[chnhbhndchngn],Please bring the original link to reprint, thank you. https://en.javamana.com/2022/02/202202130824550848.html