关系模式departments(code,name)、employees(code,name,sex,dept,phone),查询“”所在部门的其他同事清单信息,查询结果包括code,name,phone,正确的语句是()
A.
select e_id,name,phone from employees where dept in (select dept from employees where name='皓') order by name;
B.
select e_id,name,phone from employees where dept=(select dept from employees where name='张小明') order by name;
C.
select code,name,phone from employees em1,employees em2 where em1.dept=em2.dept and em1.name='张小明' and em2.name <>'张小明' order by em2.name;
D.
select em2.code,em2.name,em2.phone from employees em1,employees em2 where em1.dept=em2.dept and em1.name='张小明' and em2.name <>'张小明' order by em2.name;