Que: 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;
a. {1,2,2,3,3,5,6,7,8,8}
b. {1,2,3,5,6,7,8}
c. { }
d. None of the mentioned
Answer: {1,2,3,5,6,7,8}

Leave a Comment