ocpÌâ¿â½âÎö£º1Z0-051-V9.02-µÚ153Ì⣬ÍêÕûÌâ¿âÇëµã»÷ÕâÀïÁªÏµÀÏʦ×ÉѯÁ˽â

153. View the Exhibits and examine the structures of the PRODUCTS and SALES tables.

Which two SQL statements would give the same output? (Choose two.)

A. SELECT prod_id FROM products

INTERSECT

SELECT prod_id FROM sales;

B. SELECT prod_id FROM products

MINUS

SELECT prod_id FROM sales;

C. SELECT DISTINCT p.prod_id

FROM products p JOIN sales s

ON p.prod_id=s.prod_id;

D. SELECT DISTINCT p.prod_id

FROM products p JOIN sales s

ON p.prod_id <> s.prod_id;

Answer: AC

ÊÔÌâ½âÎö£º

A£ºËùÓеIJúÆ·ºÍÒÑÂô³öµÄ²úÆ·Ïཻ£¬¼´·µ»ØÒѾ­Âô³öÈ¥µÄ²úÆ·µÄid¡£

B:ËùÓеIJúÆ·ºÍÒÑÂô³öÈ¥µÄ²úÆ·Ïà¼õ£¬¼´·µ»ØûÓÐÂô³öÈ¥µÄ²úÆ·¡£

C:·µ»ØÒÑÂô³öÈ¥µÄ²úÆ·µÄid

D´ð°¸£º»á°ÑËùÓеĶ¼ÏÔʾ³öÀ´

INTERSECT Example The following statement combines the results with the INTERSECT operator, which returns only those unique rows returned by both queries

·µ»Ø¹²Í¬ÓеÄΨһµÄÐÐ

MINUS Example The following statement combines results with the MINUS operator, which returns only unique rows returned by the first query but not by the second

·µ»ØµÚÒ»¸öÓУ¬µÚ¶þ¸ö±íÎÞµÄÐÐ