What does the following SQL statement do? Select * From Customer Where Cust_Type = "Best"
A) Selects all the fields from the Customer table for each row with a customer labeled "Best"
B) Selects the "*" field from the Customer table for each row with a customer labeled "Best"
C) Selects fields with a "*" in them from the Customer table
D) Selects all the fields from the Customer table for each row with a customer labeled "*"

Question

Quizplus · Accepted Answer

The SQL statement selects all the fields (seen by the "*" wildcard character) from the Customer table for each row where the Cust_Type column has a value of "Best".

What Does the Following SQL Statement Do? Select * from Customer