group by columns should be "sync with select columns" after each change on query
group by should take all columns and functions/ operations that are not aggregate functions ( count, sum, avg, min, max )
exemple: select 1, f(a), 'gg', count(*) from group by 1, f(a), 'gg'
Log in to post a comment.
group by
should take all columns and functions/ operations
that are not aggregate functions ( count, sum, avg, min, max )
exemple:
select 1, f(a), 'gg', count(*) from
group by 1, f(a), 'gg'
Last edit: PAscal 2015-01-10