Query Getting the Maximum salary of the employee by department wise SUBQUERY Example

Query Getting the Maximum salary of the employee by department wise

SUBQUERY Example


select
E.fname +' '+ E.lname as EmpName
,T.Salary
,D.depname
,D.depid
from
Employenew E,
departnew D
,(select max(salary) as Salary ,depid from Employenew group by depid) as T
where
E.depid=D.depid
and T.depid=D.depid
and E.Salary =T.Salary