select 表.属性（命名空间：重名管理）
查找所有员工入职时候的薪水情况
http://www.nowcoder.com/questionTerminal/23142e7a23e4480781a3b978b5e0f33a
select distinct employees.emp_no, salaries.salary from employees, salaries where employees.emp_no=salaries.emp_no and employees.hire_date between salaries.from_date and salaries.to_date order by employees.emp_no desc;
美团二面954人在聊
查看3道真题和解析
投递新奥集团等公司8个岗位 >