Post reply

Referencing other columns in queries using group by

  • August 14, 2006 at 7:14 am

    #169919

    Good morning,

    SQL standards state that the SELECT must contain items that are in the GROUP BY list.

    I need to add an additional column (and ID field) to the SELECT without utilizing an aggregate function or adding the column to the GROUP BY.

    Does anyone have an idea on how to accomplish this?

    Thanks!

  • August 14, 2006 at 7:33 am

    #654806

    Hi,

    Given that it is an ID field there shouldn't be any reason why you cannot (or shouldn't) have it in the GROUP BY clause.

    Essentially though, it's not possible.  If you are aggregating data then you must either aggregate it, group it, or not include it in your result list.  It doesn't make sense to aggregate without a grouping.

    Karl
    source control for SQL Server

  • August 18, 2006 at 12:09 pm

    #655727

    Why do you want both groupings and an ID field?  Perhaps there is a way to do a join or a sub-query if we knew why you wanted both groups (inherently multiple rows summed together based upon a field) and an ID (normally only one per one row which nullifies grouping).

    Steve

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply