I’ve never truly used DISTINCT and felt comfortable for using it. Always felt us... | Hacker News

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

		ak39 on May 22, 2023 \| parent \| context \| favorite \| on: The many faces of DISTINCT in Postgres (2017) I’ve never truly used DISTINCT and felt comfortable for using it. Always felt using it revealed a design smell in my query. (Been doing SQL for 30 years and still!)

netcraft on May 29, 2023 [–]

yes, thats exactly the way I feel. It might be the right answer, but oftentimes its a smell.

Theres very few cases where you shouldnt be doing a group by with aggregates instead. (window functions count here)

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