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';

Question

Quizplus · Accepted Answer

Option B retrieves only the first names of all records where the last name is 'Jones'. Option A retrieves all columns for records where the last name is 'Jones'. Option C retrieves both first and last names for records where the last name is 'Jones'. Option D retrieves only the first names for records where the last name is either 'Mr. Jones' or 'Mrs. Jones', which may not include all records for just 'Jones'.

Which of the Following SQL Statements Would Retrieve Just the First