Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Gregory Larsen Stairway to T-SQL Part 2: Beyond T-SQL Basics: Level 3: Building a Correlated Subquery RE: Stairway to T-SQL Part 2: Beyond T-SQL Basics: Level 3: Building a Correlated Subquery

  • September 10, 2016 at 3:11 pm

    #1900231

    GilaMonster (9/6/2016)

    Because there's no un-aggregated columns being returned from that subquery. Group By is only needed when you have columns in aggregate and columns that aren't in aggregate in the select clause.

    Gila, thank you very much. If I learn nothing else from this stairway, I've learned this. So thanks again.