$ ./guess_the_languageSQL & Databases
SQL & Databases · medium · #16

What happens when PostgreSQL runs this?

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