Q. If in Table "employee", a column "emp_id" consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following MySQL statement?
SELECT DISTINICT emp_id
FROM employee;
SELECT DISTINICT emp_id
FROM employee;
β
Correct Answer: (B)
-indexes
Explanation: This question is about how MySQL's DISTINCT keyword works.