Try this:
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
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[
^]