Consider the relation shown in the exhibit. Which of the following SQL statements would properly remove all tuples for N
Posted: Sat Jul 23, 2022 7:29 pm
Consider the relation shown in the exhibit. Which of the following SQL statements would properly remove all tuples for New York customers?
A. DELETE * FROM Customers WHERE Sales_Office = New York;
B. DELETE FROM Customers WHERE Sales_Office = ew York?WHERE Sales_Office = ?ew York?
C. DELETE * FROM Customers WHERE Sales_Office = ew York?WHERE Sales_Office = ?ew York?
D. DELETE FROM Customers WHERE Sales_Office NOT LIKE ew York? WHERESales_Office NOT LIKE ?ew York?
- Consider The Re 1 (149.09 KiB) Viewed 90 times
B. DELETE FROM Customers WHERE Sales_Office = ew York?WHERE Sales_Office = ?ew York?
C. DELETE * FROM Customers WHERE Sales_Office = ew York?WHERE Sales_Office = ?ew York?
D. DELETE FROM Customers WHERE Sales_Office NOT LIKE ew York? WHERESales_Office NOT LIKE ?ew York?