Select from following answers:- select distinct employee-id,employee_name from employee_master;
- select distinct employee-id,employee_name from employee_master order by employe_name;
- select distinct employee-id,employee_name from employee_master order by employe_name,employee_id;
- select distinct employee-id,employee_name from employee_master order by employe_name,employee_id,employee_code;

- All Above
It will give us an error saying that
Msg 145, Level 15, State 1, Line 1
ORDER BY items must appear in the select list if SELECT DISTINCT is specified.
Means whatever columns we have used in order by clause must be used in select statement with Distinct clause.
Answer 1,2 and 3 will produce the correct answer.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator