数据库实验多表查询参考答案 数据库原理试验教材试验答案试验二(1) 找出同一天进入公司服务的员工。Select a.employeeNo,a.employeeName,a.hireDate, b.employeeNo,b.employeeName from Employee a,Employee as b where a.employeeNo!=b.employeeNo and a.employeeNameb.employeeName and (a.hireDate=b.hireDate) 参考解答： SELECT DISTINCT a.hireDate, a.employeeNo, a.employeeName FROM employee a, employee b WHERE a.employeeNo!=b.employeeNo AND a.hireDate=b.hireDate ORDER BY a.hireDate, a.employeeNo -本人不跟本人连接 - 消退重复的元组 select a.hireDate, a.employee
