I'm not an expert in traditional SQL or in Phoenix SQL, but my best guess is "probably not".
But I'm curious as to why you would like to avoid the group by or the list of columns. I know it looks very wordy, but are there any technical reasons? In my experience SQL is hard to read by human eyes by nature, so I just get used to it. On Mon, Sep 19, 2016 at 10:06 AM, Cheyenne Forbes < cheyenne.osanu.for...@gmail.com> wrote: > Hi steve, > > Thank you, it works when I add group by, can I avoid using group by or > avoid adding all my columns to the group by if I have 10 columns being > queried? >