Without DISTINCT ON (which I've never used) you can use a window function via th... | Hacker News

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

		dotancohen 66 days ago \| parent \| context \| favorite \| on: SQL Anti-Patterns Without DISTINCT ON (which I've never used) you can use a window function via the OVER clause with PARTITION BY. I'm pretty sure that's standard SQL.

ryandv 66 days ago [–]

Yes, this is the implementation I have seen in other dialects.

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