Loading

GROUP BY

PankaJ D

Can we use GROUP BY without Agrregate Functions

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Santhosh N15y ago
If you plan to use all the columns in select in group by as well then there is no need to have aggregate functions..
0
Manikavelu Velayutham15y ago
Yes its possible, but the columns present in Group By clause should be present in the selection list.

Select Column1 from table1 group by Column1
0