GROUP BY

Question

Can we use GROUP BY without Agrregate Functions

Santhosh N · Answer

If you plan to use all the columns in select in group by as well then there is no need to have aggregate functions..

Manikavelu Velayutham · Answer

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