A database table has the structure tblPhoneOrders(orderNum, custName, custPhoneNum, item Ordered, quantity). Which SQL statement could be
Question:
A database table has the structure tblPhoneOrders(orderNum, custName, custPhoneNum, item Ordered, quantity). Which SQL statement could be used to extract all attributes for orders for item AB3333?
a. SELECT * FROM tblPhoneOrders WHERE itemOrdered = "AB3333"
b. SELECT tblPhoneOrders WHERE itemOrdered = "AB3333"
c. SELECT itemOrdered FROM tblPhoneOrders WHERE = "AB3333"
d. Two of the above are correct.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
a SELECT FROM tblPhoneOrders WHERE it...View the full answer
Answered By
Tamondong Riza
Professionally, I am a teacher with years of experience tutoring math and science, as well as teaching in both public schools and independent schools. I feel that education should be an enlightening experience for all children, and I'm committed to helping my students learn new skills and make progress in their subjects.
0 Reviews
10+ Question Solved
Related Book For 
Question Posted:
