A financial services firm keeps client information in a tabl…
A financial services firm keeps client information in a table called clients. If an analyst only needs to see the first name and last name of each client, which SQL statement should they use? SELECT * FROM clients SELECT firstname, lastname FROM clients SELECT firstname AND lastname FROM clients SELECT name FROM clients Answer: SELECT firstname, lastname FROM clients Explanation: Listing column names separated by commas allows retrieval of only those specific fields. Using * would pull all fields, AND is not valid in a SELECT list, and name would be incorrect unless the table had a single name column.