News for hackers. Stuff that matters.
Re:SQL Anti-Patterns You Should Avoid by dotancohen on Saturday October 18, 2025 @12:48PM (#45628652)
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.
Re:SQL Anti-Patterns You Should Avoid by ryandv on Saturday October 18, 2025 @12:49PM (#45628656)
Yes, this is the implementation I have seen in other dialects.