8 Replies Latest reply: Dec 5, 2014 5:52 AM by Jan Heinrichsdorff RSS

    Resident statement + Group by

      Hi experts


      I have the following resident statement:



      max(txtnr) as txtnrMax

      resident Notiz GROUP BY jobnr;


      I would like to add another field let#s call it "x" which contains text. Since with the group by function the fields need a max, min eg, I do not know how to include my field that contains text.


      Anybody know a solution to this problem?