如何通过日期明智地找到工资 [英] How to find the salary through date wise

问题描述

您好我有2张桌子，

Hi i have 2 tables ,

EMPID   Name
1       Raghu
2       Venki

和

and

ID	EMPID 	Hike salary date	Salary
1       1       Jan 1st 2014    1000
2       2       Jan 1st 2014    1200
3       2     March 1st 2014    1300
4       2      june 1st 2014    1200
5       2       SEP 1st 2014    1600

1>显示员工姓名，每位员工的当前工资，加息日期。

2>显示员工姓名，每位员工的工资增量计数。



[edit]已添加代码块 - OriginalGriff [/ edit]

1> Display employee name ,current salary of each employee,with hike date.
2>Display employee name , count of salary increments for each employee.

[edit]Code block added - OriginalGriff[/edit]

推荐答案

试试这个：

Try this:

-- 1)  Display employee name ,current salary of each employee,with hike date.
SELECT E.EmpName, S2.Salary,  S1.Hike_salary_date
FROM Employees AS E INNER JOIN (
    SELECT EMPID, MAX(Hike_salary_date) AS Hike_salary_date
    FROM Salaries
    GROUP BY EMPID
  ) AS S1 ON E.EMPID = S1.EMPID
INNER JOIN Salaries AS S2 ON E.EMPID = S2.EMPID AND S1.Hike_salary_date = S2.Hike_salary_date


-- 2) Display employee name , count of salary increments for each employee.
SELECT E.EmpName, ROW_NUMBER() OVER(PARTITION BY S.EMPID ORDER BY S.Hike_salary_date) AS IncremCountOfSalary
FROM Employees AS E INNER JOIN Salaries AS S ON E.EMPID = S.EMPID

SQLFiddle [ ^ ]

我们不做你的作业：它是有原因的。它就是为了让你思考你被告知的事情，并试着理解它。它也在那里，以便您的导师可以识别您身体虚弱的区域，并将更多的注意力集中在补救措施上。



亲自尝试，你可能会发现它不是和你想的一样困难！



如果遇到具体问题，请询问相关问题，我们会尽力提供帮助。但我们不打算为你做这一切！

We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.

Try it yourself, you may find it is not as difficult as you think!

If you meet a specific problem, then please ask about that and we will do our best to help. But we aren't going to do it all for you!

这篇关于如何通过日期明智地找到工资的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！