12 Replies Latest reply: Sep 18, 2016 6:33 AM by Sunny Talwar RSS

    How to use Group By Clause

    Jim Chan

      Hi guys,

       

      i wanted to use Group By Clause. my script is as below. It didnt load succerssfully. error is "Aggregation expressions required by GROUP BY clause".

       

      What have been missing in this table?

       

      Total_Sales_Year:

      load

      EmployeeID,

      Year

      Resident Orders

      Group BY EmployeeID,Year;

       

       

      Rgds,

       

      Jim