Blog

Given the table

CUSTOMER(CustID, Name, PhoneNum, AcctBalance)

what is the standard SQL query phrase to retrieve the Name and Phone Number of customers?
A) SELECT CUSTOMER-Name AND CUSTOMER-PhoneNum
B) SELECT (CUSTOMER-Name AND CUSTOMER-PhoneNum)
C) SELECT Name, PhoneNum
D) SELECT (Name, PhoneNum)
E) SELECT *