Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following SQL statements would cre

[answerhappygod]

Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following SQL statements would create a set difference of the two relations with the widest variety of Structured Query Language dialects?

Consider The De 1 (174.01 KiB) Viewed 77 times

A. SELECT * FROM Dept1_Parts EXCEPT(SELECT PartJD FROM Dept2_Parts);
B. SELECT * FROM Dept1_Parts MINUS (SELECT Part_ID FROM Dept2_Parts);
C. SELECT * FROM Dept1_Parts DIFFERENCE (SELECT Part_ID FROM Dept2_Parts);
D. SELECT * FROM Dept1_Parts WHERE Part_ID NOT IN (SELECT Part_ID FROM Dept2_Parts);