shikong

分类

题解(2)

/ 注册

全部文章（共1篇）

单表自连接就通过了。。。

select s1.emp_no, s2.salary-s1.salary growthfrom salaries s1inner join salaries s2 on s1.emp_no = s2.emp_nowhere s2.to_date='9999-01-01'group by s1.em...

2021-03-17

47 6898