What happens when PostgreSQL runs this?
-- PostgreSQL SELECT dept, name, MAX(salary) FROM emp GROUP BY dept;
- It errors:
nameis not grouped - It picks a random name per dept
- It returns one row per employee
- It returns the top earner's name
Every selected column must be grouped or aggregated; PostgreSQL rejects
Play SQL & Databases ▸
name because a group has many names.