What SQL statement lists only the EmployeeID, LastName, and FirstName fields of all employees in the Employees

Question:

What SQL statement lists only the EmployeeID, LastName, and FirstName fields of all employees in the Employees table?

a. SELECT *

FROM Employees;

b. SELECT EmployeeID, LastName, FirstName FROM Employees;

c. SELECT EmployeeID, LastName, FirstName INTO Employees;

d. SELECT EmployeeID, LastName, FirstName WHERE Employees;ProjectID ProjectStartDate ClientID EmployeelD 06-Feb-19 1 1 2 3 4 7 9 10 11 13 14 15 16 17 18 19 20 222 21

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Concepts Of Database Management

ISBN: 9780357422083

10th Edition

Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt

Question Posted: