Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Count of accounts per zipcode RE: Count of accounts per zipcode

  • December 10, 2014 at 9:49 am

    #1763844

    Or use the ROLLUP option

    SELECT

    State

    ,ZipCode

    ,Count(Account) AS [Accounts]

    FROM YourTable

    GROUP BY State, ZipCode

    WITH ROLLUP;

    This will give a total for the State (record will be State, NULL, countTotal) and a total for the whole dataset (record will be NULL,NULL,countTotal)