1 69. View the Exhibit and examine the description for the PRODUCTS and SALES table.
PROD_ID is a primary key in the PRODUCTS table and foreign key in the SALES table. You want to
remove all the rows from the PRODUCTS table for which no sale wa s done for the last three years.
PROD_ID is a primary key in the PRODUCTS table and foreign key in the SALES table. You want to
remove all the rows from the PRODUCTS table for which no sale wa s done for the last three years.
Which is the valid DELETE statement?
本题主有点绕弯,看清题意,删除最近三年没的售前的产品。那就是三年前销售的,所以要time_id<=sysdate-3*365.