Examine the structure of the two tables: PRODUCTS Name Nul1? Type ------------------------------------ PROD_ID CHAR(2) PROD_NAME CHAR(4) EXP_DATE TIMESTAMP(6) -- NEW_PRODUCTS: Name Nul1? Type ------------------------------------ PROD_ID CHAR(2) PROD_NAME CHAR(4) EXP_DATE TIMESTAMP(6) Which two queries execute successfully?

发布于 2021-02-23 19:25:45
【多选题】
A SELECT prod_id, exp_date FROM products UNION ALL SELECT prod_id,NULL FROM new_products;
B SELECT prod_id, prod_name FROM products INTERSECT SELECT 100,prod_name FROM new_products;
C SELECT * from products UNION SELECT*FROM new_products;
D SELECT * FROM products MINUS SELECT prod_id FROM new_products;
E SELECT prod_id FROM products UNION ALL SELECT prod_id,prod_name FROM new_products;

查看更多

关注者
0
被浏览
113
  • 体验AI问答!更聪明、超智能!
  • 一款基于GPT的超级AI助手,可以对话、创作、写文案!
1 个回答

撰写答案

请登录后再发布答案,点击登录

发布
问题

手机
浏览

扫码手机浏览

分享
好友

在线
客服