--Get the second highest salary of HR department select * from #employee1 select * from #department1 ;with cte(empname,sal,row) as ( select empname,empsal,ROW_NUMBER()...