5 Replies Latest reply: Aug 9, 2016 7:32 PM by Marco Wedel RSS

    Resident, Group By, & Where clause

    Seth Rosenbauer

      I'm wondering if it is possible to use a resident load with a group by statement and a where clause. There is either a syntax error or perhaps this is not possible. Thanks for the help in advance!

       

      TempTable:

           LOAD

       

                distinct Sequence,

                Count([Sound Flag]) as NumberOfSounds

       

           Resident Sounds Group By NumberOfSounds

           Where([Sound Flag]= 'Y');