本文探讨了如何使用SQL语句来删除在过去三年内没有销售记录的产品。具体地，需要找到一个有效的DELETE语句来移除PRODUCTS表中相应的产品条目。
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.
扫一扫
1751
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
