Which of the Following SQL Statements Would Retrieve Just the First

Which of the following SQL statements would retrieve just the first name of all records for Mr. and Mrs. Jones in the memberTable?

A) Select * from memberTable Where LastName = 'Jones';
B) Select FirstName from memberTable Where LastName = 'Jones';
C) Select FirstName, LastName from memberTable Where LastName = 'Jones';
D) Select FirstName from memberTable Where LastName = 'Mr. Jones' OR LastName = 'Mrs. Jones';

Correct Answer:

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Access For Free