1.查询个人每年的年薪增长率
结果:
emp_no | from_date | to_date | salary | 差额 |
---|---|---|---|---|
10001 | 1986-06-26 | 1987-06-26 | 60117 | 上一年的年薪减去今年年薪的差额 |
10001 | 1987-06-26 | 1988-06-25 | 62102 | 上一年的年薪减去今年年薪的差额 |
10001 | 1988-06-25 | 1989-06-25 | 66074 | 上一年的年薪减去今年年薪的差额 |
......... | ......... | ......... | ......... | ......... |
........ | ......... | ......... | ......... | ......... |
......... | ......... | ......... | ......... | ......... |
sql语句:
SELECT a.*, (b.salary-a.salary) AS '差额' FROM salaries a, salaries b WHERE a.emp_no=10001 ANDb.emp_no=10001 AND YEAR(a.from_date)=YEAR(b.from_date)-1;