Answer (Choose 1 answer)
You want to retrieve Salary information for an employee called Ed from the Employee table.
following statement:
SELECT Firstname, Lastname, Salary FROM Employees
You see all the employees listed, and it's hard to find Ed's information. Which clause should the number of rows returned?
A. ORDER BY Firstname;
B. GROUP BY Firstname = 'Ed';
C. WHERE Employees = 'Ed';
D. WHERE Firstname = 'Ed';
Exit 46
