关系模式department(code,name)、employee(code,name,sex,dept,phone),查询“研发部”的员工信息,查询结果包括code,name,sex,phone,正确的语句是() A: selectcode,name,sex,phonefromemployeewheredept=’研发部’; B: selectcode,name,sex,phonefromemployeeem,departmentdewherede.code=em.deptandde.dept=’研发部’; C: selectcode,name,sex,phonefromemployeeem,departmentdewherede.code=em.codeandde.name=’研发部’; D: Selectem.code,name,sex,phonefromemployeeem,departmentdewherede.code=em.deptandde.name=’研发部’;
关系模式department(code,name)、employee(code,name,sex,dept,phone),查询“研发部”的员工信息,查询结果包括code,name,sex,phone,正确的语句是() A: selectcode,name,sex,phonefromemployeewheredept=’研发部’; B: selectcode,name,sex,phonefromemployeeem,departmentdewherede.code=em.deptandde.dept=’研发部’; C: selectcode,name,sex,phonefromemployeeem,departmentdewherede.code=em.codeandde.name=’研发部’; D: Selectem.code,name,sex,phonefromemployeeem,departmentdewherede.code=em.deptandde.name=’研发部’;
1