(
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