In the Table employee_Details there are two columns: Employee_Id-Integer[10] and Employee_Name-Char[10],The following select query Select distinct(Employee_Name) from employee_Details where Employee_Id='1232' fails due to:
The field mentioned in the where clause should be one of the columns selected
The distinct function can not be used on a field of type Char
The Integer value mentioned in the where clause should not be enclosed by quotes since it is of integer type.
none of the above.