GROUP BY clause need an aggregate ?
Asked
Active
Viewed 73 times
0
-
What would be the point without aggregate functions. – P.Salmon Dec 05 '17 at 16:30
-
No. Check this posts https://stackoverflow.com/questions/20074562/group-by-without-aggregate-function – lukasz.kiszka Dec 05 '17 at 16:30
1 Answers
3
No, an aggregate query doesn't need a GROUP BY clause. But if no such clause is present the query only generates a single result row, aggregating the entire table.
It's sort of like there was an implicit GROUP BY 'nothing' clause inserted by the DBMS if you don't provide your own.
O. Jones
- 103,626
- 17
- 118
- 172