-
If in Table “Customer”, a column “Customer_id” consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following query?
SELECT DISTINICT emp_id
FROM employee;
-
- {1,2,3,5,6,7,8}
- { }
- {1,2,2,3,3,5,6,7,8,8}
- All of above
- None of these
Correct Option: A
DISTINICT keyword will remove the duplicate entries in the result set.