Free CompTIA ITF+ FC0-U61 Practice Question
In a company's employee database, there is a table named 'Employees' that includes fields such as 'ID', 'Name', 'Department', and 'Email'. You are asked to retrieve a list of the names and email addresses of all employees who work in the 'Marketing' department. Which query would you use to accomplish this task?
SELECT Name, Email FROM Employees;
SELECT Name, Email FROM Employees WHERE Department = 'Marketing';
SELECT * FROM Employees WHERE Department = 'Sales';
SELECT Department FROM Employees WHERE Name = 'Marketing';
This question's topic:
CompTIA ITF+ FC0-U61 /
Database Fundamentals
SAVE $17