Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Kathi Kellenberger Using a Window Aggregate in an Aggregate Query RE: Using a Window Aggregate in an Aggregate Query

  • April 26, 2015 at 1:39 am

    #1793500

    palotaiarpad (4/26/2015)

    Hmm. According to BOL, if OVER used with a SUM, then an order by clause is required...

    That is incorrect, it is the partition clause and in this case the empty over() is a shorthand for it.

    😎