Create view for get Highest Salary for Each Department using SubQuery

CREATE View [dbo].[VU_SecondHSalaryEachDept]
AS
SELECT  Department, MAX(TotalSalary) Salary FROM VU_EMP_Employees  AS TempTable
WHERE TotalSalary <
(SELECT MAX(TotalSalary)
FROM VU_EMP_Employees
WHERE Department = TempTable.Department)
GROUP BY Department
GO