News for hackers. Stuff that matters.
Re:Medium-hard SQL interview questions by GlennS on Saturday May 02, 2020 @10:15PM (#23056359)
It covers up bad queries, so you may not see an underlying data duplication problem.

Often better to group explicitly so you know what's actually going on.

Re:Medium-hard SQL interview questions by matwood on Sunday May 03, 2020 @07:37AM (#23058403)
> It covers up bad queries,

Bingo. I used to work with a guy who would see duplicate results and just throw a distinct on his query. I had to keep on him to fix his queries or explain why distinct was correct in this case. My default is that distinct is almost always not the solution.