You work as a Database Administrator for Domain.com. The company uses MySQL as its
database.
You have created a table named Employees in the database. You want to create a list of
employees working in the organization, but you do not want to display any duplicate row in the
report. Which of the following statements will help you to accomplish the task?
A.
SELECT emp_id, emp_name FROM Employees ORDER BY emp_id;
B.
SELECT emp_id, emp_name FROM Employees;
C.
SELECT DISTINCT emp_id, emp_name FROM Employees;
D.
SELECT emp_id, emp_name FROM Employees GROUP BY emp_id;