April 5, 2015

How to get max Salary from each department in SQL

DECLARE @Table TABLE
(
       ID INT,
       Name VARCHAR(20),
       Salary NUMERIC(8,2),
       Department VARCHAR(20)
)

INSERT INTO @Table
SELECT 1001,'Jhon',10000,'IT' UNION ALL
SELECT 1002,'Mac',12000,'IT' UNION ALL
SELECT 1003,'Philip',13000,'AC' UNION ALL
SELECT 1004,'Disj',10000,'AC' UNION ALL
SELECT 1005,'Mathew',10000,'HR' UNION ALL
SELECT 1006,'Sk',16000,'HR'

SELECT Department,MAX(Salary) 'Max Salary In Dept' FROM @Table
GROUP BY Department

No comments:

Post a Comment