5 Replies Latest reply: Oct 15, 2014 8:25 AM by Massimo Grossi RSS

    group by statement

      Hi Experts

       

      Ich habe the following load-statement and would like to group by jobnr:

       

      SQL SELECT "auf_datum",

          bez as Leistungstext,

          jobnr,

          storniert,

          optional,

          verkauf_soll as VK_soll,

          verkauf_ist as VK_ist,

          einkauf_ist as EK_ist,

          auf_brutto as EK_soll,

      FROM EASY.jleistg

      WHERE    storniert = 0       

              and optional = 0;

       

      How do I have to put the "group by jobnr" expression?

       

      Thank you very much for your help!

       

      Jan