Does GROUP BY clause needs an aggregate function??

Question

In MySQL I've seen "GROUP BY" work without any aggregate functions but the general syntax is quite different...... Can anyone please clear this contradiction??

Answer 1

Well, it works in Postgres
https://drive.google.com/file/d/1Lw3ZYTMhYe0achq-Dt83KDU7mFbwRA_g/view

Answer 2

yup you're right buddy
sorry for wasting your time 😊

Answer 3

Rustem Sharipov it won't work anywhere else other than mysql

Answer 4

It never worked in Postgres

Answer 5

thanks Shin one Chan sort of a famous cartoon character 🤣

Answer 6

Aggregate functions can be omitted. E.g.instead of:
Select customer,Sum(sales) Group by customer
we can just run:
Select customer Group by customer

Answer 7

NULL_ptr It works. At least in MySQL, in SQL Server and in PostgreSQL.

Answer 8

NULL_ptr no problema frd!

Answer 9

It's works. The result will be the same as if use DISTINCT clause with the same columns but usually GROUP BY is faster.