(Choose 1 answer)
You want to retrieve Salary information for an employee called Ed from the Employee table. You write the 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 you add to reduce the number of rows returned?
A. WHERE Firstname = 'Ed';
B. WHERE Employees = 'Ed';
C. GROUP BY Firstname = 'Ed';
D. ORDER BY Firstname;
