使用子查询使时间等于最小时间 select s1.emp_no, s1.salary from salaries s1 where s1.from_date = ( select min(s2.from_date) from salaries s2 where s2.emp_no = s1.emp_no group by s2.emp_no ) order by s1.emp_no desc
