From my understanding, when using an aggregate function we have to GROUP BY all the other columns apart from the aggregate function, is that correct?
If above is yes, is there a way to repeat them in the GROUP BY without having to re-write each again?
SELECT COUNT(COL1), COL1, COL2, COL3
GROUP BY [all columns apart from COUNT(COL1)]
- Is it possible to specify more than one aggregate functions with its own GROUP BY?
SELECT count(COL1), max(COL1), COL1, COL2
GROUP BY [for count(COL1) group by COL1, for max(COL1) group by COL2]