使用子查询

使用子查询使时间等于最小时间

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