Groupby in SQL

--Aggregate Functions

CREATE TABLE salary
(
        empno     varchar(10),
        Dept     varchar(50),
        salary     money,
        year     varchar(10)
)

INSERT    INTO salary
SELECT    '112','admin',80000,2008

SELECT    *
FROM    Salary WITH(NOLOCK)

SELECT    SUM(salary)
FROM    Salary

SELECT    Dept,SUM(salary) as "salary"
FROM    Salary
--WHERE    Dept='Admin' and Year=2008
GROUP BY Dept

SELECT     Dept,SUM(salary)
FROM     Salary
GROUP BY Dept

SELECT        Count(Dept) AS C,Dept AS D
FROM        Salary
GROUP BY    Dept

SELECT Dept
FROM   salary

SELECT Count(Dept) AS C,Dept AS D
FROM Salary Sal
GROUP BY Sal.Dept