Only if there's a separate Departments table, which for this very simple example... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		dymk on May 22, 2023 \| parent \| context \| favorite \| on: The many faces of DISTINCT in Postgres (2017) Only if there's a separate Departments table, which for this very simple example, there isn't

maweki on May 22, 2023 [–]

Even if there were a separate Departments table, who is to say that the Department Name is not its primary key? The Department name certainly is A key.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact